Hi,

One possible solution would be to use named ranges. Let's say you wanted to
lookup a cell from the range A1:B100 of the worksheet named January, the
normal formula would be =VLOOKUP(A1,January!A1:B100,2,0) but if you name that
range say "rng1" then it could be shorten to =VLOOKUP(A1,rng1,2,0), this is
just an example but if you have to reference another sheet in your formula 4
or 5 times it would shorten it quite a bit.

HTH
Jean-Guy

"Fred "Djinn" Holstings" wrote:

What can I do if I have a formula that greatly exceeds that limit? If there a
way I can store portions of the formula in different areas and then do some
sort of concatenation?



"Dave F" wrote:

1024 characters: http://office.microsoft.com/en-us/ex...992911033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Fred "Djinn" Holstings" wrote:

I was wondering if there is a maximum number of characters that a formula can
be?

Like 255 or 360??

Thanks.
Fred