Unhide worksheet

[graiggoriz]

Hello,

I am using the below macro to unhide worksheet:

Please Login or Register  to view this content.

My problem is for instance when I delete the worksheet with "CURRENT2" the macro stops working. Would you a way make that work? knowing that I have the worksheets are CURRENT1, CURRENT2, CURRENT3, CURRENT4, CURRENT5, CURRENT6.

What I was looking forward is to having the possibility to if I delete the CURRENT2 to have the macro to unhide the CURRENT3...

Hope I am clear enough, please get back to me if not.

Thanks,
Graig

[Olly]

Change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[mikerickson]

Your code is explicitly stopping when it tries to unhide a nonexistent sheet.
Perhaps this. (Add another OR condition if you anticipate more sheets that CURRENT99)

Please Login or Register  to view this content.