Macro replacing links

G

GastonFranzini

Hi,

I have a little big problem, I hope someone could help me.
I made a Macro that replaces the sheet name of a lot of links via a
simple text replacing, my problem is that when the cell I replace
doesn't find the sheet it stops replacing. Is there a way of replacing
it anyway?

Thanks
 
A

Alan

If you mean is there a way to stop your macro bombing out when it can't
find a sheet name try ...

On Error Resume Next
<your text replacing code>
On Error GoTo 0

Regards,
 
Top