View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Souriane Souriane is offline
external usenet poster
 
Posts: 7
Default Macro Special Paste - Value

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