2,462
社区成员
发帖
与我相关
我的任务
分享
Sub getDataFromA()
Dim r&
Dim c&
For c = 2 To 30
For r = 1 To 26
Cells(r, c).Formula = "=R[-(26*(c-1))]C"
Next
Next
End Sub
Dim strTemp$, a$, b$
a = "1A"
b = "&H20"
strTemp = a & b 'strTemp ----> "1A&H20"
strTemp = a + b 'strTemp ----> "1A&H20"
strTemp = b & 5 'strTemp ----> "&H205" '5 被转换!
strTemp = b + 5 'strTemp ----> "37" '注意 b 被转换!
strTemp = a + 5 ' 异常! ----- “类型不匹配”
Sub getDataFromA()
Dim r&
Dim c&
For c = 2 To 30
For r = 1 To 26
Cells(r, c).Formula = "=R[" & 26 * (c - 1) & "]C[-" & c - 1 & "]"
Next
Next
End Sub