Is it possible to Copy From or Paste To a hidden sheet?
Copy from hidden sheet
=======================
Worksheets("Hidden").Range("A1:E5").Copy Worksheets("Sheet1").Range("A1")
Copy to hidden sheet
=======================
Worksheets("Sheet1").Range("A1:E5").Copy Worksheets("Hidden").Range("A1")
Adjust your sheet names, copy ranges and destination upper left destination
cell as appropriate for your setup.
--
Rick (MVP - Excel)
"Tom Joseph" wrote in message
...
Is this possible?
If so, I would appreciate a bit of example code.
I greatly appreciate any help.
Best regards,
Tom
|