Job,

Do you consider a formula like:

=SUM(A1:A3)

an internal link?

Would converting all formulas to values work, or do you need to still have formulas work?

HTH,
Bernie
MS Excel MVP


"Job" wrote in message ...
Anyone written anything that will find all Internal links and paste special values? Because an
internal link can be =C2 or =Sheet1!C2 I see you could look for the "!", but what about the other
link =C2?

Cheers,

Job