| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| Want to Copy and paste to new sheet range except hidden rows. | Excel Programming | |||
| copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
| copy and paste hidden rows | Excel Worksheet Functions | |||
Linear Mode
