Formula limit work around?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 12 Dec 2006 05:01 GMT

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

Reply to this Message

T. Valko - 12 Dec 2006 05:42 GMT

We would need to see the formula.

Biff

>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
[quoted text clipped - 4 lines]
>
> Jeff

Reply to this Message

Roger Govier - 12 Dec 2006 06:42 GMT

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.

Signature

Regards

Roger Govier

>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
[quoted text clipped - 4 lines]
>
> Jeff

Reply to this Message

Rate this thread: