JimmyTheHand
06-29-2009, 01:12 AM
Hi Guys,
I've met a strange thing recently. Please run the code below on a new, empty worksheet, then look at the range around A3000. Looks like the total height of 2000 rows is the same as the total height of 3000 rows...
Any ideas why is this so?
Sub test()
Dim i as Long
For i=2 To 3000
Range("A" & i).Value = Range("A1:A" & i).Height
Next
End Sub
Jimmy
I've met a strange thing recently. Please run the code below on a new, empty worksheet, then look at the range around A3000. Looks like the total height of 2000 rows is the same as the total height of 3000 rows...
Any ideas why is this so?
Sub test()
Dim i as Long
For i=2 To 3000
Range("A" & i).Value = Range("A1:A" & i).Height
Next
End Sub
Jimmy