Autofill several formulas down by a specified number

[elleb]

Hi all

I have a spreadsheet with several formulas in row 7, I want to autofill the specific formula down by a number specified in cell A1.

At the moment I am using:-
Range("B7:B" & Range ("A1").Value).Formula = Range ("B7").Formula

However I have to do this for each column which is taking time to write out and is a long VBA code.

Is there a simpler formula that would cover B7:DF7 in one go?

[Fluff13]

How about

Please Login or Register  to view this content.

[elleb]

How about

Please Login or Register  to view this content.

Absolutely perfect thank you so much!

[Fluff13]

You're welcome & thanks for the feedback