B
Betsy Yonn
I'm getting this error message, "Unable to set the
FormulaArray property of the Range class" on a worksheet
in which this formula previously worked. I referred to
the MS Knowledge Base Article 817775. This workaround
method worked for the first row of formulas. When I moved
on to perform this method on any other row, it returned
0's as values or some other erroneous value that I know is
not right. I can find nothing wrong with the spreadsheets
I use to generate the nested conditional sum formulas.
When I break down the nests as individual formulas, they
work. Can anyone help me resolve this problem??
FormulaArray property of the Range class" on a worksheet
in which this formula previously worked. I referred to
the MS Knowledge Base Article 817775. This workaround
method worked for the first row of formulas. When I moved
on to perform this method on any other row, it returned
0's as values or some other erroneous value that I know is
not right. I can find nothing wrong with the spreadsheets
I use to generate the nested conditional sum formulas.
When I break down the nests as individual formulas, they
work. Can anyone help me resolve this problem??