Microsoft Office Forums - View Single Post - [Solved] Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas

rsrasc · 08-19-2018, 07:50 AM

Quote:

Originally Posted by jeffreybrown

When pasting values only, you need to use two lines in the macro...

Code:

Sub ValuesOnly()
    Workbooks("050 FY 2019 Expenses-SSE.xlsx").Sheets("Excel Sum-Reforecast-FY 18").Range("A4:A98").Copy
    Workbooks("FY 18-SSE Actuals Plus Reforecast Budget.xlsx").Sheets("050-REVENUE").Range("A4:A98").PasteSpecial xlPasteValues
End Sub

https://www.thespreadsheetguru.com/t...-only-with-vba

Hi Jeffrey,

Thank you for the code, and is working great.

Much appreciated.

Cheers!