Tab Names and Wildcards
Posted by Sherry on February 15, 2002 4:38 PM
I need some help with a Macro. I have several (over 25) different spreadsheets that I am opening via a macro, looping through a folder, opening one by one.
That's the easy part, the hard part is that in each spreadsheet, there are multiple tabs. The tab that I need to pull in each sheet ends with the word UPL (for upload). For example, there's a tab called "Region 5 UPL" in the first spreadsheet, the second spreadsheet has a tab called "Region 6 UPL" and so on.
I need to tell the macro to select sheets containing the letters "UPL". Anyone know how to do that?? I tried Sheets.("*UPL*).Select but that does not work (I was hoping the * would represent a wildcard. Please help if you can. Thanks!!!!!!