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

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

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