Add formula to multible cells !

Hi this one feels it should be easy but im going cracy here.

I have a overview page and when i press a button i want formulas to be added to specific cell.
Im using this code to add the formula to the cell:

Please Login or Register  to view this content.

When i press the button i want the code to add it to Range A1:A1000
and to save me some time i wonder if its any way to add it directly to the range and not like this:

Please Login or Register  to view this content.

I know how to add the formula to a range of cells but in this case the range in the formula has to change
as above.

Petter

try this

Please Login or Register  to view this content.

Could you send the small sample of wokrbook?

So this should be ok

Please Login or Register  to view this content.

In Tom's 4th line
even these will work

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

I'd prefer:

Please Login or Register  to view this content.