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