array

[co-oplearning]

I have been importing lots of data from another program (Aspen) using an Excel Add-In.

In each cell containing the data, the Add-In uses this formula:

=ATGetAgg("AI_886_G1", "MASCCD02", "", 'G1 Monthly Compliance Report'!$B$2, 'G1 Monthly Compliance Report'!$D$2, "15m", 10, 0, "5m", 1, 1040, 0, 0)

My Problem:
When data is missing, the cell is blank. In order to make all my formulas and cell references work, I need to be able to manually input a zero.

However when I try to do this, I get the error message "You cannot change part of an array."

Is there a way to input 0's into these blank cells without deleting the formula. I need the formula to remain so I can use the same sheet again when new data is available.

THANKS so much for your help!