This function copies used range of handed worksheet and replaces it with values only.
Source Code
1
2
3
4
5
6
7
8
9
10
11
12
' @Author - Alexander Bolte' @ChangeDate - 2014-10-09' @Description - Copy / Pasting contents of handed Worksheets UsedRange' as values into the same range.' @Param trg - a Worksheet object holding data.' @Remarks -' UsedRange of worksheet will be overwritten by itself pasting only values and nothing else.' Formulas will be lost.PublicFunctioncopyPasteWorksheetValues(ByReftrgAsWorksheet)trg.UsedRange.Copytrg.UsedRange.PasteSpecialxlPasteValuesEndFunction