work with invisible sheet

  • Thread starter Thread starter Oli6865
  • Start date Start date
O

Oli6865

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
 
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)
 
You can certainly reference data in a hidden sheet. Reference it
just as you would if the sheet were not hidden.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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
 
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 said:
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 ?
Click to expand...
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide multiple worksheets based on a formula value in one cell 1
Workbook_BeforeSave 8
How do you chart data from multiple sheets within a workbook? 3
Autohide rows based on formula in another sheet 0
Keep lot of sheets Displayed and Hide Other 2
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
HIDE / UNHIDE sheets based on user answers 5
Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) 3

Back
Top