Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Repeat Code Repetitive Actions?
I am doing some list comparing and I have to do a lot of the same actions
(specifically, highlight three cells, insert, shift cells down) Is there a way I can code that action into a shortcut key? |
#2
|
|||
|
|||
Check out the Help info on Recording Macros. They can have shortcut keys
assigned to them and can also be attached to custom toolbar button & command buttons, and can be added to your Menu. Good Luck |:) "chris" wrote: I am doing some list comparing and I have to do a lot of the same actions (specifically, highlight three cells, insert, shift cells down) Is there a way I can code that action into a shortcut key? |
#3
|
|||
|
|||
Just to add to CyberTaz's reply.
When you turn on the record macro stuff, you'll be prompted for a name (and where to save it) and if you want a shortcut key. If you forget to assign the shortcut key here, you can assign it later: tools|macro|macros select your macro Options button and assign it there. And you'll see a toolbar pop up. One of those icons on that toolbar allows you to use Relative references. This means that the actions will be taken with respect to the activecell. If you don't toggle that option, your macro will get recorded using the actual address of the cell you're working on. If you run a macro like that, you'll do the same thing over and over and over to the same cell. If you have trouble fixing up your code, paste it (just the code, not the workbook) into your follow up message. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm chris wrote: I am doing some list comparing and I have to do a lot of the same actions (specifically, highlight three cells, insert, shift cells down) Is there a way I can code that action into a shortcut key? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost my Paste | Excel Discussion (Misc queries) | |||
Help with Amending this Code Please | Excel Worksheet Functions | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Zip Code Macro | Excel Worksheet Functions |