How to copy range and paste as values
 

Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1")



Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

How to copy range and paste as values
 

Hi Tom,

Unlike the normal Copy Paste single line of code, use 2 separate lines of
code when using PasteSpecial.

You probably know this but just in case: Space and underscore at the end of
a line is a line break in an otherwise single line of code.

Worksheets("Outliers_1").Cells.Copy

Worksheets("Outliers").Range("A1").PasteSpecial _
Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

--
Regards,

OssieMac


"Tom Joseph" wrote:

Worksheets("Outliers_1").Cells.Copy Worksheets("Outliers").Range("A1")



Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False