Is there a way to overcome the the formula size limit of 1024. MS indicates about 32k is the permissible character length, but apparently formulas are treated differently (even though I could not find this documented in MSDN or TechNet). No, my users will not accept the result of the formula instead.
My code simply creates an array of row numbers needing to be totaled at the end, so it's just a matter of simple addition of cell references (e.g. "=A1+A13+A25..."). Any suggestions on a workaround??
Thanks all.
This message was edited by jmeeko on 2002-12-10 14:53
My code simply creates an array of row numbers needing to be totaled at the end, so it's just a matter of simple addition of cell references (e.g. "=A1+A13+A25..."). Any suggestions on a workaround??
Thanks all.
This message was edited by jmeeko on 2002-12-10 14:53