Pasting Value only

[Ark68]

If I am using this method of copying data between worksheets, how can I limit the pasting at the destination to value only? Right now it is pasting formulae and formatting, which I con't want.

.Range("A2:A" & lastrow_data).Copy Destination:=wshALL.Range("a13")

 

[TiaXL]

.pastespecial xlpastevalues

 

[jeffreybrown]

When pasting values it has to be on two lines.

    .Range("A2:A" & lastrow_data).Copy
    wshALL.Range("a13").PasteSpecial xlPasteValues

 

[Ark68]

Thank you so much folks!

 

[jeffreybrown]

You're welcome...Glad it worked for you