Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
I am trying to get relative reference to work while using my macros. The
help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
The toggle doesn't appear when using the macros, it appears when recording
the macro (so that either relative or absolute references are used.) -- Kevin Vaughn "PhillipsHQ" wrote: I am trying to get relative reference to work while using my macros. The help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
ToolsCustomizeToolbars.
Select the Stop Recording Toolbar. Start Recording a macro then hit the Stop button. DO NOT hit the "x" to stop or you will lose the Toolbar again. Gord Dibben MS Excel MVP On Thu, 17 Aug 2006 14:56:03 -0700, PhillipsHQ wrote: I am trying to get relative reference to work while using my macros. The help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
Thanks a lot. I should have been more clear with my request. I did, in
fact, mean that the pop-up did not occur when creating the macro...nice catch. "Kevin Vaughn" wrote: The toggle doesn't appear when using the macros, it appears when recording the macro (so that either relative or absolute references are used.) -- Kevin Vaughn "PhillipsHQ" wrote: I am trying to get relative reference to work while using my macros. The help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
Home run. Thanks a million...
"Gord Dibben" wrote: ToolsCustomizeToolbars. Select the Stop Recording Toolbar. Start Recording a macro then hit the Stop button. DO NOT hit the "x" to stop or you will lose the Toolbar again. Gord Dibben MS Excel MVP On Thu, 17 Aug 2006 14:56:03 -0700, PhillipsHQ wrote: I am trying to get relative reference to work while using my macros. The help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? Gord Dibben MS Excel MVP |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Reference Help Macros
I see that Gord correctly interpreted what you meant and provided the answer.
After I saw his reply, I figured that was more likely what you meant. Glad he answered your question for you. -- Kevin Vaughn "PhillipsHQ" wrote: Thanks a lot. I should have been more clear with my request. I did, in fact, mean that the pop-up did not occur when creating the macro...nice catch. "Kevin Vaughn" wrote: The toggle doesn't appear when using the macros, it appears when recording the macro (so that either relative or absolute references are used.) -- Kevin Vaughn "PhillipsHQ" wrote: I am trying to get relative reference to work while using my macros. The help menu says there should be a pop-up toggle switch that allows me to select between absolute and relative references. That button never appears. Ideas, please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
GETPIVOTDATA() with relative reference | Excel Worksheet Functions | |||
Relative Cell Reference | Excel Worksheet Functions | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
"relative reference" question | Excel Discussion (Misc queries) |