How to copy range and paste as values

T

Tom Joseph

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



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

OssieMac

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
 
Top