At the moment I have a bunch of formulas along the top row of a sheet and I
wish to copy them down a predfined number of rows. At the moment I activate
the sheet and then select the rows I want to copy down with the row
containing the formulas at the top and the just use fill down.

It would be much cooler if I could accomplish this in the background as it
were without having to select the
sheet. Is there a way of effectively filling down the formula without having
to activate the sheet?

Any help much appreciated, kind regards, Mark