dadasdas 发表于 2013-2-18 15:55
A = .Range("A4").CurrentRegion
For i = 2 To UBound(A)
数组A的A4当前区域是哪,i变量从2开始到数组最 ...
MsgBox .Range("A4").CurrentRegion.Address(0, 0) '返回A4:AF33
A = .Range("A4").CurrentRegion
'i=1对应源表中第4行(上面赋值语句中,不是指定了A4的当前区域么)
'而源表第4行,就是有很多编号编号的,是不需判断的内容
'所以,真正需判断的数据是从第4行的下一行(i=1的下一个值,当然是i=2)开始的
For i = 2 To UBound(A)
看下面这个UBound(a),是不是指列标号
Sub Macro1()
Dim wb As Workbook, sh As Worksheet, c As Range, r As Range, rng As Range, lr As Long
Dim a, b, d As Object, i&, arr, brr()
Set d = CreateObject("scripting.dictionary")
a = Array("项目", "编号")
b = Array("序列", "序号")
For i = 0 To UBound(a)
d(a(i)) = b(i)
Next