View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
 
Posts: 69
Default work with invisible sheet

Oli6865 wrote:
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 ?

Sure.

Sheets("Sheet2").Range ("A1") = Sheets("Sheet1").Range ("A1")


The thing you can't do this is to select hidden sheet so, code below
will not work


Sheets("Sheet1").Range("A1").Select
Sheets("Sheet2").Range ("A1") = Selection.value


and it is how macro recorder usually records macros.