![]() |
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 |
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