Copy/Paste only values

[Session101]

Hey guys,

How do I copy and paste values only in VBA using the .Copy method?

My current code is listed below, but it does a normal copy/paste:

Sheets("Inv").Rows(LSearchRow).Copy Sheets("CA").Rows(LCopyToRow)

Thanks!

[davegugg]

To do that you need to break it into two lines like this:

Sheets("Inv").Rows(LSearchRow).Copy 
Sheets("CA").Rows(LCopyToRow).PasteSpecial xlValues

[Leith Ross]

Hello Session101,

You can do this two different ways. First, you can modify your copy statement to use PasteSpecial.

Sheets("Inv").Rows(LSearchRow).Copy 
Sheets("CA").Rows(LCopyToRow).PasteSpecial Paste:=xlPasteValues

The second way is by direct assignment. This method only works with the Value property. Eventhough the Value property is the default property for a Range, you still must specify the property for the block transfer to work.

Sheets("Inv").Rows(LSearchRow).Cells.Value = Sheets("CA").Rows(LCopyToRow).Cells.Value