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

[Tom Joseph]

Is this possible?

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

I greatly appreciate any help.

Best regards,

Tom

 

[Rick Rothstein]

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.

 

[Heera]

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

 

[Rick Rothstein]

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.

 

[Tom Joseph]

Thanks Rick,

I really appreciate the help.

Best regards,

Tom

 

[Tom Joseph]

Thanks Heera,

I really appreciate the help.

Best regards,

Tom

 

[Tom Joseph]

Hi Rick,

This worked fine.
Worksheets("Hidden").Range("A1:E5").Copy Worksheets("Sheet1").Range("A1")

Instead of "A1:E5" I want to copy the entire sheet and also paste it as
values.

Can you help with this?

Thanks.

 

[Rick Rothstein]

Try this statement...

Worksheets("Hidden").Cells.Copy Worksheets("Sheet1").Range("A1")

Remember to change the destination worksheet name if necessary.

 

[Tom Joseph]

Thanks, Rick.

Try this statement...

Worksheets("Hidden").Cells.Copy Worksheets("Sheet1").Range("A1")

Remember to change the destination worksheet name if necessary.