Hello everybody
I have this code that do auto numbering
The problem is that the code is very slow because of loop ..Is there a way to do the same task quickly?
Sub AutoNumer() Dim I As Long Dim Cell As Range, Rng As Range Set Rng = Range("A1:A100000") Rng.ClearContents I = 1 For Each Cell In Rng Cell.Value = I I = I + 1 Next Cell End Sub
Bookmarks