View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default work with invisible sheet

Or select the sheet itself... Also note that if the sheet is not active then
there is no active cell on the sheet. Any references to the active cell are
alway to the active sheet.
--
HTH...

Jim Thomlinson


"Chip Pearson" wrote:

You can do anything with a hidden sheet that you can with a
visible sheet except select a cell on it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Oli6865" wrote in message
ups.com...
Thanks to both of you :-)
It'll be useful, but I just have another little Q, can you
delete a
column in a hidden sheet ?

Oli