error trapping for sheet rename

[Xtopher]

Hi there,

I am using a VBA macro to rename a set of sheets in a workbook.

Please Login or Register  to view this content.

No issues there. However, if one or more of the sheets have been removed from the workbook I would like the macro to skip over the missing sheet and continue to the next sheet as there are a total of 30 sheets this macro renames at any given time.

Any help would be greatly appreciated.



Thanks in advance,
Chris

[HaHoBe]

Hi, Chris ,

you could either use

Please Login or Register  to view this content.

what would continue with the code no matter what error shows up (maybe leading to unwanted results in Variables) or use a function to determine whether a sheet exists like

Please Login or Register  to view this content.

to be called

Please Login or Register  to view this content.

Ciao,
Holger