ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro replacing links (https://www.excelbanter.com/excel-discussion-misc-queries/104265-macro-replacing-links.html)

[email protected]

Macro replacing links
 
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


Alan

Macro replacing links
 

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,



All times are GMT +1. The time now is 08:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com