We help IT Professionals succeed at work.

Paste Values

Seamus2626
Seamus2626 used Ask the Experts™
on
Hi,

I have some code that copys data from one worksheet to another. The trouble is it copys formula, i need it to be a paste special, can anyone amend?

   
   ThisWorkbook.Sheets("Sheet2").Range("A1").CurrentRegion.Copy _
        Workbooks("Treats file for Merit.xls").Sheets("Output").Range("A" & Rows.Count).End(xlUp)(2)

Thanks
Seamus
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try this Seamus (two separate lines):

ThisWorkbook.Sheets("Sheet2").Range("A1").CurrentRegion.Copy
Workbooks("Treats file for Merit.xls").Sheets("Output").Range("A" & Rows.Count).End(xlUp)(2).PasteSpecial xlValues

Author

Commented:
Thanks Stephen, thats worked perfect

Thanks Alan, i wasnt able to work that link out though