I'm simply trying to take a worksheet out of a workbook and save it into a new workbook; but the contents in the workbook should be value-only. (The original workbook is cluttered with formulas).
This code works for me, but it copies over the original cells as value-only before it saves to the new workbook. Looking for ideas to preserve the formulas in the original workbook.
Worksheets("Input").Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
Set wbNew = ActiveWorkbook
wbNew.SaveAs "C:\Users\dholmoe\desktop"
wbNew.Close True