| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Activecell in hidden sheet
ActiveCell only exists on the acitve sheet. Since you can not activate a
hidden sheet therw is no way to determine the active cell on that sheet. You need to unhide the sheet and then activate it to get the active cell. Or (would be my preference where possible) remove all references to the active cell. -- HTH... Jim Thomlinson "BOBODD" wrote: Is there anyway of setting the activecell address on a hidden sheet without unhiding the sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Activecell in hidden sheet | Excel Programming | |||
| Selecting ACTIVECELL range in Macro - | Excel Programming | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
| selecting a cell relative to activecell in an excel macro | Excel Programming | |||
Linear Mode
