Horje
vba copy paste value only Code Example
vba copy paste value only 
Sub CopySheetPasteAsValues()
    Sheets("Sheet1").Cells.Copy
    Sheets("Sheet1").Cells.PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub



3

Related
excel-vba how to convert a column number into an excel column Code Example excel-vba how to convert a column number into an excel column Code Example
vba code to remove duplicates from a column Code Example vba code to remove duplicates from a column Code Example
excel vba check if directory exists Code Example excel vba check if directory exists Code Example
excel vba wait Code Example excel vba wait Code Example
xl vba check for folder Code Example xl vba check for folder Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje