Question : excel vba copy entire sheet paste values
Answered by : vastemonde
Sub CopySheetPasteAsValues() Sheets("Sheet1").Cells.Copy Sheets("Sheet1").Cells.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False
End Sub
Source : | Last Update : Fri, 22 Jan 21