提示错误 运行时错误‘1004’方法‘Range’作用于对象‘_Global’时失败
Dim i As IntegerDim n As Integer
Dim m As String
n = 0
m = "02"
For i = 1 To 3
n = n + 1
m = m + 1
m = Format$(m, "00")
MsgBox ("""" & m & """")
Range("""" & m & """").Select
ActiveCell.FormulaR1C1 = "=MATCH(RC[-13],财管类!R[-" & n & "]C[-12],R[272]C[-12])"
Next i
End Sub
提示错误 运行时错误‘1004’
方法‘Range’作用于对象‘_Global’时失败
调试的时候出错的语句
Range("""" & m & """").Select
如果改成range("04").select 就没有问题?
--------------------编程问答-------------------- 你这样
Range(m).Select --------------------编程问答-------------------- 谢谢!!!!
补充:VB , VBA