![]() |
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? |
All times are GMT +1. The time now is 11:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com