Macro Special Paste - Value

  • Thread starter Thread starter Souriane
  • Start date Start date
S

Souriane

I would like to have a macro in Excel that, when I do Shift+CTRL+V does

Special Paste - Value.

I found this on internet:

Sub CreatePasteShortCutKeys()
Application.OnKey "+^v", "PasteValue"
End Sub

Sub PasteValue()
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

But it won't work. I am not too good at macros, someone can help me?
Another macro or somethings wrong I might have done?

Souriane
 
Souriane,

Did you copy something before running the macro using shift-ctrl-v? It works fine for me...

HTH,
Bernie
MS Excel MVP
 
Souriane,

Did you run the macro

CreatePasteShortCutKeys

to assign the shortcut key combo?

HTH,
Bernie
MS Excel MVP
 
Thank you very much Bernie!
Now it works!!!

Your help was very much appreciated!

Souriane
 
Back
Top