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.
|