/VBA/Excel vba copy entire sheet paste values

Excel vba copy entire sheet paste values

Sub CopySheetPasteAsValues()
    Sheets("Sheet1").Cells.Copy
    Sheets("Sheet1").Cells.PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub

Similar codes

0 vote415 views1 answer
Amd64 vs arm64 linux
VBA
1 vote293 views1 answer
Excel vba array remove first
VBA
0 vote294 views1 answer
Find if year is leap year vb
VBA
0 vote305 views1 answer
Excel vba unmerge sheet
VBA
5 votes296 views1 answer
Xl vba double quotes in string literal
VBA
8 votes370 views1 answer
Vba make a short integer from two bytes
VBA
0 vote310 views1 answer
Excel vba named range exists
VBA
0 vote287 views1 answer
Make all controls in an area not visable vb
VBA
0 vote308 views1 answer
Set datetimepicker value to null vb
VBA
0 vote287 views1 answer
Xlbycolumns is not declared
VBA