Macro code to continue iterating if error.

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,

try using this in your code

Please Login or Register  to view this content.

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.