Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
how do i record new macro so that when i run it, it
starts from the selected cell and not revert back to the cells that i recorded it in? thanks, desperate! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
When you're recording the macro, you'll see two icons on that "stop recording"
toolbar. The second one is "relative reference". Click it and see if that does what you want. Or maybe you could just examine the existing recorded code and start using ActiveCell instead of the original's address. You may want to post back if you have trouble. There might even be ways of not selecting anything at all. (Usually the code is easier to follow and runs a little quicker, too.) hh wrote: how do i record new macro so that when i run it, it starts from the selected cell and not revert back to the cells that i recorded it in? thanks, desperate! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |