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

jeffreybrown · 08-19-2018, 06:55 AM

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