How Do You Enter Array Formula Via VBA?

[modytrane]

I have following Array formula in Cells N1:N3.

Each formula has different text in "".

There are a few macros in this workbook that delete and/or insert rows.
When that happens, the formulas listed above get modified with different references.

How do I restore the formulas back to the same range reference [O$4:O$1000]?

Thanks,
modytrane