View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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?