View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default work with invisible sheet

Yes it is. If you want to address it in VBA, use the worksheet codename, the
name you see in the explorer in the VBIDE that is not in brackets, you can
address a cell directly

Sheet1.Range("A1")

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Oli6865" wrote in message
oups.com...
Hi to all,

I'd like to know if it's possible to use data from a "visible = False"
sheet ?

To look neat, in a workbook, I hide a sheet that contains my raw data
and would like to use the data in this hidden sheet to display graphs
in another (visible) existing sheet.

Is this possible ?

Thanks all :-)

Oli