Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ok, sorry if I wasn't gettig it before. I don't believe you can do that in
one module. You'll have to have two macros, with two short-cuts. Or you could experiment, write 2 macros, then copy code from one Macro to the other, and see if the short cuts work. "pm" wrote: Kou Vang wrote: You will have the option of running the Macro with a Ctrl + keyboard key. So, the answer is yes. (of course you would not be allowed standard short cut options of ctrl+c or ctrl+v) i know that, but is a possibility of operating macro with shortcuts. ie. when pressed ctrl+shift+v then active range select and copy when pressed ctrl+shift+c the selected range paste with transposition and horizontal flip both shortcuts in one module... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keyboard Shortcuts for Paste Special Values and Formats | Excel Discussion (Misc queries) | |||
Excel should have keyboard shortcuts for paste value/format | Setting up and Configuration of Excel | |||
Excel should have keyboard shortcuts for paste value/format | Setting up and Configuration of Excel | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |