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:

[A1].FormulaLocal = "=SUMMA(Sheet2!A1)"

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:

[A1].FormulaLocal = "=SUMMA(Sheet2!A1)"
[A2].FormulaLocal = "=SUMMA(Sheet2!A2)"
[A3].FormulaLocal = "=SUMMA(Sheet2!A3)"
Etc.

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