Saturday, October 10, 2020

How to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel

 How to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel


How to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel






Sub PasteVal()
    Selection.PasteSpecial Paste:=xlValues
End Sub


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.

No comments:

Post a Comment

Lion King 2019 Telugu Movie | Lion King Telugu Movie | Lion King Telugu Version Movie

  Lion King 2019 Telugu Version Movie has been released and running successfully in theaters. Telugu Top Heros J agapathi Babu and Nani g...