Question

VBA 方法‘range’作用于对象‘_Global’时失败

Dim i As Integer
For i = 0 To 10
Cells(i, 2) = 234
i = i + 1
Next

Answer 1

For i = 0 To 10 ' 改成 for i = 1 to 10

因为 i= 0时 ，Cells(0, 2) 没有此单元格的位置 ,因此报错！