I've come across a couple of methods of making all sheets in a
workbook values only. The routines I have have a tentency towards
unexpected errors and they take a while to run e.g below. Has anyone
got an alternative method I could try.
Any help appreciated
'==Private Function MakeSheetValuesOnly(mySheetName As String)
Application.CutCopyMode = False