| Home |
| Search |
| Today's Posts |
|
#4
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 |
| 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 | |||
Threaded Mode
