Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following macro:
' Keyboard Shortcut: Ctrl+Shift+e ' Selection.Insert Shift:=xlDown I use this to copy data and insert. I don't like too use the mouse so I use Shortcut keys. The problem is that I have to always go back and copy my selection each time I use Ctrl+Shift+e. For example I have in cell A1 "JOE". I want to go to A1, use Ctrl C - copy and then go to multiple areas in my sheet, press Ctrl+Shift+e and insert and shift down "JOE". When I use my macro it does it once and then does not work again unless I go back to cell A1 and copy again. How can I fix this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selection copy and insert to other sheet (Macro) | Excel Discussion (Misc queries) | |||
Copy Insert Macro | Excel Discussion (Misc queries) | |||
Macro to insert a row and copy down formulas from row above | Excel Discussion (Misc queries) | |||
Macro - Insert/Copy | Excel Discussion (Misc queries) | |||
Macro to Insert and copy entire row | Excel Discussion (Misc queries) |