xlPasteValues method doesn't work

Hi, I am having trouble with the following code that selects all rows to the bottom starting with 2nd row in on workbook, and pastes into another. Everything work fine if I use just Paste, but the code breaks if I am using PasteSpecial xlPasteValues. Why is it happing? How can I paste values using the code I've created so far?

    Application.Goto Reference:="R2C1:R2C100" 'where R is row and C is column.
    Range(Selection, Selection.End(xlDown)).Select
    ActiveSheet.PasteSpecial xlPasteValues

Open in new window

Dmitriy KritskiyAsked:
Who is Participating?
NorieVBA ExpertCommented:
The destination for PasteSpecial is a range, not a sheet.

Try this.
targetws.Range("A2").PasteSpecial xlPasteValues

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.