Hi,
Can someone help me with this?
I'm trying to write some code that will hide all tabs in a workbook that have tab names that end with "U" or "C", and leave all other tabs visible.
I know how to write a macro to hide all tabs except tabs with a "known" tab name, but for this application I need a wildcard character for the first ( name length - 1 ) characters, or something.
There can be anywhere from 100 tabs to many hundred that I need to hide, and all are almost always named in the form:
001U
...
030C
...etc.
Occasionally if the numbers extend beyond 999C or 999U there will be 5 character tab names: 1020U, etc.
The purpose of this is to easily pull out the dozen or so tabs that do not end in "U" or "C", so the code I'm trying to write doesn't necessarily have to just hide tabs. If someone knows how to read all the tab names from a workbook and write them to cells in a column on a sheet in that workbook, that would spectacular...
Thanks!
Bookmarks