| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activesheet.name ending in "-" &Style1
I'm trying to find all sheets that end in "-" & Style1
If ActiveSheet.Name Like "??-" & Style1 Then If ActiveSheet.Name Like "???-" & Style1 Then If ActiveSheet.Name Like "????-" & Style1 Then The sheetname could begin with 2 to 4 letters and always ends in - and Style1 (another series of characters) Style1 is 1-3 characters long. TIA Gerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - How do I keep an ending space in a cell? i.e. "Mr. " | Excel Discussion (Misc queries) | |||
| ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007 | Excel Programming | |||
| Change "With Worksheets" to "Activesheet" | Excel Programming | |||
| How do I keep a 17 digit number from ending in "0" in excel? | Excel Discussion (Misc queries) | |||
| What are the reasons for ""ActiveSheet.Paste Link:=True"" failure | Excel Programming | |||
Threaded Mode
