[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

RE: Selecting Activecell in hidden sheet

Jim Thomlinson

12/14/2006 11:25:00 PM

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?