Cells
行列从1开始
Cells(1,1)=123
Cells(1,”A”)=123
Range
Range(“B2”)
Range(“B3:F4”)
Range(“B3:F4,B2,D7:E8”)
Range(Cells(r1,c1), Cells(r2,c2))
VBA调用Excel函数
Cells(2, 2) = WorksheetFunction.Sum(Range(“A1:A10”))
Excel调用VBA自定义函数
模块中定义函数,即可在Excel中调用自定义函数
Public Function Add(x As Integer, y As Integer)
Add = x + y
End Function