| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
With Sheets("wildcard")
How can I use a wildcard in a With Sheets statement? I have written a macro
that works on sheet ScoreCard. However, during the export process if the end user saves the workbook rather than open it ScoreCard is changed to ScoreCard.Bob or ScoreCard.Alice. I need to do something like this to make the macro work With Sheets("ScoreCard*") but that doesn't work. Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIFS equivalent in Excel 2003 - both criteria have text, one has "wildcard" | Excel Worksheet Functions | |||
| "For each w in workbooks "can't find ".dat" open excel sheets, | Excel Programming | |||
| SHEE1. Duplicate all sheets, making 2 copies of ea. / 2. Add " E"and " F" to end of tab name. / 3. Put all sheets at the very end. | Excel Programming | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
Threaded Mode
