|
请看看下面的代码为什么第二步不计算呢?
在引用模块进行完成后,想将引用后的数据进行求和,于是想用call 求和进行 但是不成功,什么原因呢?
Dim m As Integer
For m = 6 To 21
Cells(m, "s") = Application.WorksheetFunction.Sum(Range(Cells(m, "C"), Cells(m, "R")))
Next m
End Sub
Sub 引用()
Dim i As Integer
Dim y As Integer
For i = 3 To 18
x = Cells(5, i).Value
For y = 6 To 21
Cells(y, i) = Sheets("" & x).Cells(y, "N")
Next y
Next i
call 求和
End Sub
|
|