Copy Value from row 2 down to row 100

[hallingh]

I have a formula in row 2 of columns A:BY that I want to copy down to rows 3:100 using vba, but I'm not sure how to do it.

Basically just trying to save myself some time and not have to click and drag the formula for each column.

Thanks for any help you can give me!

Hank

 

[VoG]

Try like this

Range("A2:BY2").AutoFill Destination:=Range("A2:BY100")

 

[braindiesel]

Range ("A2:A100").select
Selection.FillDown

 

[hallingh]

That worked perfectly. Thanks for saving me a whole lot of time!

Hank

 

[pgc01]

I have a formula in row 2 of columns A:BY that I want to copy down to rows 3:100 using vba

Hi Hank

Remark:

You say you want to copy the formulas.

Fill methods will also copy formats in addition to copying the formulas. Is it what you want?