vba resize question

[redspanna]

Hi all,

simple question (if you know the answer I guess)...

current line of code will copy formula down 100 lines

.Range("B" & Aw).AutoFill Destination:=.Range("B" & Aw).Resize(100)

what do I add or change to make the above line copy the formula UP?

thanks

 

[pgc01]

Hi redspanna

Try:

.Range("B" & Aw).AutoFill Destination:=.Range("B" & Aw).Offset(-99).Resize(100)