Hi all
I like to auto fill numbers
i have a macro like this and works fine
But the problem happen some time i have only 1 line so it need to enter only 1 not the 2 and not autofill until the end
any advise
I like to auto fill numbers
i have a macro like this and works fine
VBA Code:
Range("A1") = "Line"
Range("A2") = "1"
Range("A3") = "2"
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Range("A2:A3").autofill Destination:=Range("A2:A" & LastRow)
any advise