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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
How to copy Range and Paste as Values (from hidden sheet) 2
conso macro 0
lenghty code 4
Copy Paste Macro not Pasting Values when Blank 3
Copy paste - Values - formula - Optimise 2
Copy and paste range ontime 2
Simplify Code for Copy/Paste Special 11

Top