|
表中A列为不连续的一列数字编号从260000到280000(数字类型),想把A列中的空号取出放在B列。请老师支招,谢谢了
- Sub test()
- Dim arr, d, i&, k&
- Set d = CreateObject("scripting.dictionary")
- For i = 260000 To 280000
- d(i) = ""
- Next
- arr = Range("a1:a" & [a65536].End(3).Row)
- For k = 1 To UBound(arr)
- If d.exists(arr(k, 1)) Then
- d.Remove (arr(k, 1))
- End If
- Next
- Range("b1").Resize(d.Count, 1) = WorksheetFunction.Transpose(d.keys)
- End Sub
复制代码
|
|