Quickly paste only values
January 11th, 2011
The following macro will be the same as ‘Paste Special’ -> ‘Values’.
Assign a keyboard shortcut to the macro and it will significantly improve work speed.
Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub
