Error messages

[DAE]

How can I fix a "Formula is too long" error that occurs during search &
replace operations? Thanks.

 

[Bob Umlas]

ummmm... shorten the formula?

 

[Farhad]

I need to see your formula and see if i can shrink it but the final sugestion
would be to split your formula in 2 cells i mean do half of your formula in
one cell and do the rest in another cell.

Thanks

 

[DAE]

I could do that but the workbook is complex enough already. The formulas are
long due to long pathnames in references, not due to complex operations, and
they work error-free as is. But I need to change the pathnames. Do you know
if there is a limit on number of characters or something else that is
specific to search & replace?

 

[DAE]

Good idea in theory but see my response to Farhad

 

[Farhad]

I think the limitation is 1024 characters well you need to make short the
file names and folder names. or see if your can go other way and make your
formula shorter.

Thanks

 

[DAE]

Thanks. I'll start out working with the 1024 length.