Copy array

[Kofod]

Hey Guys,

Haven't worked with VBA in Excel for years and its slightly frustrating...(considering throwing my computer out the window at this point)

here is the super ridiculous simple thing i want to do:

Sub Array_Formula()
Sheets("Pantebreve").Range([indirect("A1000"]).Formula = Sheets("Amortizationsberegner").Range("B7:NN11").Formula
End Sub

A1000 in the "Pantebreve" sheet contains this: ER22:TD26
This value is relative to a dropdown of names, so can't be hardcoded.
The start number is the crucial one "ER22".
"TD22" is simply calculated to make the same range as B7:NN11

Im getting this:
Run time error '1004':
Application-defined or object-defined error

Sorry for such a noob question, but its driving me nuts.

Thanks!!!!!

 

[steve the fish]

Hi. Do the indirect like this:

Sheets("Pantebreve").Range(Sheets("Pantebreve").Range("A1000"))

 

[Kofod]

Thank you, thank you, thank you!!!!!