Souriane,

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

HTH,
Bernie
MS Excel MVP


"Souriane" wrote in message
ups.com...
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