Macro code to continue iterating if error.

[sid9221]

Hi,

I am trying to rename 2 tabs each on 60 files, this is the code I have below.

Please Login or Register  to view this content.

The problem is, some of the files have the tabs named correctly or have a name other than the one specified in my macro.

Eg: 70% of the files have the tabs named "EXCEPTION 3 MONTH", 20% have "EXCPTION 3 MONTH" and 10% have "EXCEPTIONAL 3 MONTH" as the tab names.

Is there a way I could I force all other names of the tabs to be changed to the new one ?

Thanks,

[Sean Thomas]

try using this in your code

Please Login or Register  to view this content.

[Sean Thomas]

sorry, forgot to take the msgbox's out of the code.
Just using those to check it was working.

Please Login or Register  to view this content.

[mehmetcik]

I haven't tested this but something like this is what you need.

Please Login or Register  to view this content.