How do I paste special values with Destination:=Worksheets

I'm running the following code:

Please Login or Register  to view this content.

Which works fine. But I want to paste special values except when I try this:

Please Login or Register  to view this content.

I'm getting a syntax error. How do I make this work?

bishoposiris,

The issues is the multiple argument nature of .PasteSpecial. I don't believe you can use it along with the destination function. It should work to simply put the paste function at the end of a normal cell reference. Basically shuffling the code around and dropping the "Destination:=" part of it.

Please Login or Register  to view this content.

You may already have this, but you would probably want a line in your code that ends the "Cut Copy" mode:

Please Login or Register  to view this content.

I hope this helps,

DarkF1ame

sourabhg98, your first suggest give me error: Run-time error '438': Object doesn't support this property or method. Your second suggestion cuts the number from .Range("D" & RowCount).Value but does nothing with it. It continues through the For loop and the cell still has the "cut lines" around it. But nothing got pasted.