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?