| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy Range and Paste as Values (from hidden sheet)
I am using the following to copy from a hidden sheet and paste to another
sheet. Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1") I would like to paste just the values. The destination sheet is not hidden, if that matters. Can someone please tell me what addtional code I need to add to acomplish this? Thanks, Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy Range and Paste as Values (from hidden sheet)
Hi Tom,
This should do the paste by value for you. Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1").PasteSpecial Paste:=xlPasteValues Hong Quach "Tom Joseph" wrote: I am using the following to copy from a hidden sheet and paste to another sheet. Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1") I would like to paste just the values. The destination sheet is not hidden, if that matters. Can someone please tell me what addtional code I need to add to acomplish this? Thanks, Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy Range and Paste as Values (from hidden sheet)
Thanks. I appreciate the help.
"Hong Quach" wrote: Hi Tom, This should do the paste by value for you. Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1").PasteSpecial Paste:=xlPasteValues Hong Quach "Tom Joseph" wrote: I am using the following to copy from a hidden sheet and paste to another sheet. Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1") I would like to paste just the values. The destination sheet is not hidden, if that matters. Can someone please tell me what addtional code I need to add to acomplish this? Thanks, Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to Copy From or Paste To a hidden sheet? | Excel Programming | |||
| copy and paste range of cells excluding hidden data in excel | 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) | |||
Linear Mode
