请让我知道如何正确地设置一个表的部分范围，作为计算其简单移动平均值的来源，子范围的子范围。（数据源表命名为“Skandi”，记录平均值的目标表命名为“MovAvg”）
错误源于VBA脚本的以下声明，在模块中以红色标记：

Sub movingaverage()

Dim MovAvg As Worksheet: Set MovAvg = Sheets("MovAvg")
Dim Skandi As Worksheet: Set Skandi = Sheets("Skandi")
Dim xHeti As Long: xHeti = 6      ' time span for calculating averages
Dim sz As Long: sz = 35       ' Nr of columns in table
Dim Col As Long                   
Dim Row As Long                  

For Col = 1 To sz
    For Row = 1 To Skandi.Range("namedRange").Rows.Count
     Dim fCell As Range: Set fCell = Skandi.Range("namedRange").Cells(Row, Col)    
     Dim lCell As Range: Set lCell = Skandi.Range("namedRange").Cells(Row + xHeti, Col)
     Dim AvgRng As Range: Set AvgRng = Range(fCell, lCell)                                                                         
        MovAvg.Cells(7 + Row, Col) = WorksheetFunction.Average(AvgRng)     ' fault here. Marked yellow !                                                  
       
    Next Row
Next Col
End Sub

我在这个网站上查看了相关的问答，但这些还没有为我提供救助。