Macro to Create a Short Cut Key to Paste Special values in Excel | VBA Code to Create a Short Cut Key to Paste Special values in Excel | Macro to Create a Short Cut Key to Paste Special values in Excel

Macro to Create a Short Cut Key to Paste Special values in Excel | VBA Code to Create a Short Cut Key to Paste Special values in Excel | Macro to Create a Short Cut Key to Paste Special values in Excel 

How to Paste Macro in Excel Module

Open Excel Sheet and Press Alt F11 Keys.

A New Window will Open and go to Insert Menu. 

In Insert menu click on Module.

After inserting Module, a new window will open and copy and paste the above code in that window.

save the code after pasting in  the module.
Before this process, make excel sheet as Macro-Enabled Work Sheet.

Sub PasteVal()

    Selection.PasteSpecial Paste:=xlValues

End Sub