VBA Autofill

[ziad alsayed]

dear all

long time, hope you are all fine.

i am trying to avoid using a loop. the below code is hard coded. how can in make it general as the number of row varies every time.

Selection.AutoFill Destination:=Range("C2:C33237")

i had the code but just can' find it

appreciate any help. thanks in advance.

 

[VoG]

Try like this

Dim LR As Long
LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
Range("C2").AutoFill Destination:=Range("C2:C" & LR)

 

[ziad alsayed]

dear VoG

perfect as usual , thanks