Try,

r.FormulaArray = r.Offset(-1, 0).FormulaArray

Mike

"Barb Reinhardt" wrote:

It appears when I programmatically copy an array formula using something like
this:

r.formular1c1 = r.offset(-1,0).formular1c1 'where r is a range.

The array formulas need to be committed with CTRL SHIFT ENTER. Is this
happening to anyone else? What do I need to do to get these to copy
correctly?

FWIW, I'm still using 2003.
Thanks,
Barb Reinhardt