| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fastest way to select a sheet codename
I have the following code (which really bothers me):
Select Case ws.CodeName: Case "Sheet1" : ' Do stuff Case "Sheet2" : Case "Sheet3" : ' Do stuff Case "Sheet4" : ' Do stuff Case "Sheet5" : ' Do stuff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Sheet By Codename | Excel Programming | |||
| Fastest way to select large range (e.g. B3:F1002)? | Excel Discussion (Misc queries) | |||
| change sheet codename | Excel Programming | |||
| Selecting a sheet by codename | Excel Programming | |||
| Using sheet codename problems | Excel Programming | |||
Threaded Mode
