Help with macro to unhide all tabs with a #

[aaron061883]

Can anyone help me adjust this code to unhide all tabs with a #. The Bold red # is where the tab you wanted unhidden identified. But there are # tabs 1-90 that would need to be unhidden. Any help would be great.

Please Login or Register  to view this content.

[humdingaling]

not sure i understand the problem

But there are # tabs 1-90 that would need to be unhidden

what exactly do you mean by this?
how are the sheet names actually written?

[aaron061883]

1, 2, 3, 4, 5, ...... all the ways to 90 and as you go higher some of the smaller #'s are hidden and then at the end or during the job all the sheets need to be unhidden. there are also other sheets that are hidden that i don't want to unhide and that why i am not using a macro to unhide all sheets.

[humdingaling]

so # is actually a number not "#" itself?
ie the sheet name is actually just 1,2,3,....88,89,90?

also another way to think of it....with so many number fields..maybe easier to decide what not to hide instead?

[jolivanes]

Like this?

Please Login or Register  to view this content.

If the names are just numbers as suggested above, this does not work of course.

[aaron061883]

Did not work

[aaron061883]

The sheets does not have # sign its a value between 0-9

[humdingaling]

if Sheet name is only number as then this should work

Please Login or Register  to view this content.

[aaron061883]

Perfect we are in business thank you