Blog‎ > ‎IT‎ > ‎

Excel VBA copy sheet values only

posted Dec 28, 2013, 1:36 AM by Jake Vosloo   [ updated Dec 28, 2013, 1:53 AM ]
Today I wanted to copy the values from every sheet in one workbook into a new workbook with only the values.  Here is what worked for me eventually:

For Each Sheet In Sheets
    Set NewWorkbook = Workbooks.Add
    NewWorkbook.Sheets.Item(1).Cells(1, 1).PasteSpecial Paste:=xlPasteValues

The URLs where I found advice were in no order of preference: