看走眼了,不过应该少不了遍历循环的。用SpecialCells可以少循环一点。其实写入数组再来循环应该也不慢的。
Sub test()
Dim rng As Range, rg As Range
Set rng = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants)
For Each rg In rng
Debug.Print rg.Value
Next
End Sub
看走眼了,不过应该少不了遍历循环的。用SpecialCells可以少循环一点。其实写入数组再来循环应该也不慢的。
Sub test()
Dim rng As Range, rg As Range
Set rng = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants)
For Each rg In rng
Debug.Print rg.Value
Next
End Sub