Hell All,
A VBA related question.
I have used the following to save all worksheets as values only - removing formulas etc.
Sub Saveasvalue()
'Updateby Extendoffice
Dim wsh As Worksheet
For Each wsh In ThisWorkbook.Worksheets
wsh.Cells.Copy
wsh.Cells.PasteSpecial...