copying formulas from two columns down to the last cell in those columns

[tanyaleblanc]

Im trying to autofill the formula in cell A3 and B3 down to the last cell in those two columns using D as my anchor. but the code is not working. I'm getting an error message under " Selection.AutoFill Destination:=Range("A3:B3: & lrow")"



lastrow = Cells(Rows.Count, "D").End(xlUp).Row
Range("A3:B3").Select
Selection.AutoFill Destination:=Range("A3:B3: & lrow")

 

[Fluff]

It should be

Selection.AutoFill Destination:=Range("A3:B" & lastrow)

 

[tanyaleblanc]

perfect, thank you again,

 

[Fluff]

You're welcome & thanks for the feedback