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?