cav~firez22
Well-known Member
- Joined
- Jun 21, 2006
- Messages
- 543
If i have this
How can i get it to auto fill down to the last row of data instead of always row 150.
basically as far as there is data in colum A, i want B1 to autofill down.
could some one help me get that?
thanx
Code:
ActiveCell.FormulaR1C1 = "ATLANTA"
Selection.AutoFill Destination:=Range("B1:B150")
How can i get it to auto fill down to the last row of data instead of always row 150.
basically as far as there is data in colum A, i want B1 to autofill down.
could some one help me get that?
thanx