PasteSpecial xlPasteValues Compile Error

Hi everyone,

When I add the ".PasteSpecial . . . " at the end of the following line, I am getting Compile error "Expected: end of statement" and I can't figure out how to fix it.

Please Login or Register  to view this content.

Any help, please?

Gos-C

You cannot copy and paste values on a single line of code... you would have to copy the range first and then PasteSpecial the values on a second line. However, since we are talking of copying contiguous values only... don't copy them, just assign them directly...

Please Login or Register  to view this content.

Ah! I understand. Great, thank you very much, Rick.