Formula limit work around?

J

Jeff

I have a user who is using a formula which has reached the 1024 limit. Can
this formula be split up into two cells? Or can I use VBA to re-engineer the
formula?

Any formulas in VBA would be appreciated or any other suggested work
arounds.

Jeff
 
R

Roger Govier

Hi

You could possibly take parts of the formula and enter them as defined
names with Insert>Name>Define.
Then refer to those names within the rest of the formula.
 
Top