Is it possible to Copy From or Paste To a hidden sheet?
 

Is this possible?

If so, I would appreciate a bit of example code.

I greatly appreciate any help.

Best regards,

Tom

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

Is it possible to Copy From or Paste To a hidden sheet?
 

Here is the code.....

Assume you are in sheet2 and run the macro.
hide sheet1 and put some value in Cell A1 of sheet1
It will work fine.

Sub Macro4()
'
ActiveCell.Value = Sheets("Sheet1").Range("A1").Value
Sheets("Sheet1").Range("A2").Value = 500

End Sub

Is it possible to Copy From or Paste To a hidden sheet?
 

By the way, you should note that it is not necessary to do a 2-step
operation (copy first then paste).... you can simply copy to your
destination directly.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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

Is it possible to Copy From or Paste To a hidden sheet?
 

Thanks Rick,

I really appreciate the help.

Best regards,

Tom

"Rick Rothstein" wrote:

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

Is it possible to Copy From or Paste To a hidden sheet?
 

Thanks Heera,

I really appreciate the help.

Best regards,

Tom

"Heera" wrote:

Here is the code.....

Assume you are in sheet2 and run the macro.
hide sheet1 and put some value in Cell A1 of sheet1
It will work fine.

Sub Macro4()
'
ActiveCell.Value = Sheets("Sheet1").Range("A1").Value
Sheets("Sheet1").Range("A2").Value = 500

End Sub