Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Special Paste - Value
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Special Paste - Value
Yes I did Bernie.
Nothing happens when I do "shift ctrl v" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Special Paste - Value
Souriane,
Did you run the macro CreatePasteShortCutKeys to assign the shortcut key combo? HTH, Bernie MS Excel MVP "Souriane" wrote in message ups.com... Yes I did Bernie. Nothing happens when I do "shift ctrl v" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Special Paste - Value
Thank you very much Bernie!
Now it works!!! Your help was very much appreciated! Souriane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Macro/Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming |