relative referencing

[immyjimmy]

I have recorded my macro, and it works fine. But only on the cell I recorded it on. How do I get it to apply changes relative to where the active cell is when I execute the macro? I have looked relative references in the HELP file and also done a search here. But I can't seem to find what should be a simple thing.

Thanks is advance,
Jim

 

[Mark W.]

Did you press the "Relative Reference" button on the Stop Recording toolbar?

 

[immyjimmy]

I don't have "Stop Macro Recorder" toolbar. Is this something in "View"?

Jim

 

[Mark W.]

It should be displayed when you choose the Tools | Macro | Record New Macro... menu command.

 

[lenze]

If it doesn't show up, right click on any toolbar while recording and you can select it

 

[immyjimmy]

Right click a toolbar while recording it. I never woulda thunk it.


Thanks, that took care of it.


Jim