ExcelBanter - paste special

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - paste special (https://www.excelbanter.com/excel-programming/371829-paste-special.html)

Mona

paste special

I have this code:

..Range("J" & cnt).Copy Sheets("results").Range("J" & cnt)

What is the proper syntax to add on the end to do a paste special values only?

Jim Thomlinson

paste special

Why copy paste? This will work...

Sheets("results").Range("J" & cnt).value = .Range("J" & cnt).value

But if you want to then
..Range("J" & cnt).Copy
Sheets("results").Range("J" & cnt).PasteSpecial(xlValues)
application.cutcopymode = false
--
HTH...

Jim Thomlinson

"Mona" wrote:

I have this code:

.Range("J" & cnt).Copy Sheets("results").Range("J" & cnt)

What is the proper syntax to add on the end to do a paste special values only?

Die_Another_Day

paste special

Hi Again :)

..Range("J" & cnt).Copy
Sheets("results").Range("J" & cnt) .PasteSpecial (xlPasteValues)

Charles

Mona wrote:
I have this code:

.Range("J" & cnt).Copy Sheets("results").Range("J" & cnt)

What is the proper syntax to add on the end to do a paste special values only?

All times are GMT +1. The time now is 04:14 AM.