I have tried to do this and I think that the simple answer is that you may
have to do this manually. There are multiple limits on formulae length -
array formulae are limited to (I think) 120 characters, but regular formulae
are (I think) 255 characters. But they are treated differently if entered in
VBA or in the user interface. You can check out Chip Pearsons website - I
think he documents all the lengths somewhere.

When I encountered this, rather than spend ages on working out the
limitations I just threw a dialogue box asking the user to manually amend the
links and the restart the code.

Sorry for not being able to answer positively, thought the workaround many
be useful though.


--
www.alignment-systems.com


"Irina" wrote:

Hello!
Plz, help me change link source in LONG formula when source moved or renamed.
When open workbook with such links or on the other computer, formula
damages, and change source already crashed.
Method ChangeLink of workbook object does'nt work too.
How to do my "user defined functions" Excel feels as its own?
May be, I should place my xla in a special folder?
Thank you in advance.
Irina