How to copy Range and Paste as Values (from hidden sheet)

[Tom Joseph]

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

 

[Hong Quach]

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]

Thanks. I appreciate the help.

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