Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
work with invisible sheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
work with invisible sheet
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 "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
work with invisible sheet
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
work with invisible sheet
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
work with invisible sheet
Thanks to all of you, I got my macro working :)
Oli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
How to make hidden sheet invisible | New Users to Excel | |||
Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
color filled cell invisible on work screen | Excel Worksheet Functions | |||
Vb macros to schedule the excel sheet invisible mode | Excel Programming |