Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a macro using relative cell reference?
I would like to set up a macro using a relative cell reference (I am using
Excel 2002). The instructions say to click on the relative reference on the Stop Recording toolbar. I do not have this toolbar. I cannot find it on the toolbar list. How do I find this relative reference button, or how do I work around it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a macro using relative cell reference?
Start recording a macro
then do tools=customize click on the stop recording entry the toolbar should appear. The right button on the toolbar (2 buttons total) is the relative absolute recording toggle. Stop recording. Now, if you start recording the toolbar should appear. If you close it by using the X at the top, you will have to repeat the steps above to get it back. -- Regards, Tom Ogilvy "Vivyans" wrote in message ... I would like to set up a macro using a relative cell reference (I am using Excel 2002). The instructions say to click on the relative reference on the Stop Recording toolbar. I do not have this toolbar. I cannot find it on the toolbar list. How do I find this relative reference button, or how do I work around it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro relative cell reference | Excel Worksheet Functions | |||
Relative reference? in macro | Excel Worksheet Functions | |||
Using relative reference in macro | Excel Discussion (Misc queries) | |||
Start relative reference macro from specific cell | Excel Programming | |||
MACRO Relative Reference | Excel Programming |