|
原帖由 lhwhc 于 2011-3-14 20:40 发表
另外,怎么把数据提取到指定列?
Sub test()
Dim d As Object, arr, i%, j%
Set d = CreateObject("Scripting.dictionary")
arr = Range("B4:I" & Range("B65536").End(3).Row)
For i = 1 To UBound(arr)
If i Mod 2 = 1 Then
For j = 1 To UBound(arr, 2)
If arr(i, j) <> "" Then
d(arr(i, j)) = ""
End If
Next j
End If
Next i
[j3].Resize(d.Count) = Application.Transpose(d.keys)
End Sub
这是代码,如果你要改变数据输出的位置,你只需改变[j3].Resize(d.Count) = Application.Transpose(d.keys)中的"j3",比如你将其改为A12,即[a12].Resize(d.Count) = Application.Transpose(d.keys),那么数据列将从A12开始显示。 |
|