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.

Sheets("Sheet1").Range(Cells(r, "H"), Cells(r, "J")).Copy Sheets("Sheet1").Range(Cells(colBnr, "B"), Cells(colBnr, "D")).pastespecial xlpastevalues
Any help, please?

Gos-C