Macro Special Paste - Value

[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

 

[Bernie Deitrick]

Souriane,

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

HTH,
Bernie
MS Excel MVP

 

[Souriane]

Yes I did Bernie.

Nothing happens when I do "shift ctrl v"

 

[Bernie Deitrick]

Souriane,

Did you run the macro

CreatePasteShortCutKeys

to assign the shortcut key combo?

HTH,
Bernie
MS Excel MVP

 

[Souriane]

Thank you very much Bernie!
Now it works!!!

Your help was very much appreciated!

Souriane