|
- Sub compare()
- Dim crr()
- arr = Sheets("调整前").UsedRange
- Brr = Sheets("调整后").UsedRange
- ReDim crr(1 To UBound(arr), 150)
- Set d = CreateObject("scripting.dictionary")
- For i = 3 To UBound(arr)
- crr(i, 1) = arr(i, 6)
- crr(i, 2) = arr(i, 1)
- crr(i, 3) = arr(i, 7)
- crr(i, 4) = arr(i, 4)
- Next
- MsgBox crr(9, 1)
- Sheets("总表").Rows("1:" & Rows.Count).Delete
- Sheets("总表").Range("a1").Resize(UBound(arr), 150) = crr
- End Sub
复制代码 这个代码,到 MsgBox crr(9, 1) 是有值的,但是 填充到sheets("总表")的时候,效果是
为什么不是从第一列开始填充呢,求大师指点。。。
- Sub compare()
- Dim crr()
- arr = Sheets("调整前").UsedRange
- Brr = Sheets("调整后").UsedRange
- ReDim crr(1 To UBound(arr), 1 To 150)
- Set d = CreateObject("scripting.dictionary")
- For i = 3 To UBound(arr)
- crr(i, 1) = arr(i, 6)
- crr(i, 2) = arr(i, 1)
- crr(i, 3) = arr(i, 7)
- crr(i, 4) = arr(i, 4)
- Next
- MsgBox crr(9, 1)
- Sheets("总表").Rows("1:" & Rows.Count).Delete
- Sheets("总表").Range("a1").Resize(UBound(arr), 150) = crr
- End Sub
复制代码
|
|