| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activating correct worksheet
Hi
The code Worksheets(Names).Activate or Select brings up error 9 Subscript out of range if sitting in the Names Worksheet, but will activate if sitting in any other sheet, why? What am I missing? I just want to be sure the Formatting sub procedure called up runs on the correct sheet. TIA -- Thank you Regards Aussie Bob C. Using Windows XP Home + Office 2003 Pro |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Worksheet and Activating it | Excel Discussion (Misc queries) | |||
| Activating a Worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet activating | Excel Programming | |||
| Worksheet activating | Excel Programming | |||
| Activating a worksheet | Excel Programming | |||
![Robert Christie[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
