/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

1 vote272 views2 answers
Vba function return array
VBA
0 vote245 views1 answer
Add items to combobox vb.net
VBA
0 vote270 views2 answers
Excel vba protect cells with formula
VBA
0 vote398 views1 answer
Vba array of integers
VBA
4 votes271 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote280 views1 answer
.net crash app
VBA
0 vote253 views1 answer
Vbide vbproject reference
VBA
0 vote291 views1 answer
Create links in msgbox in vb
VBA
0 vote281 views1 answer
Delete all controls in an area vb
VBA
0 vote276 views1 answer
Vba code for cutoff time
VBA