| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to record macro with relative addressing in Excel 2000
Attempt to record a macro with relative addressing. I have R1C1 option
checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
"Rond" wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
On the Recording Toolbar there should be a Relative Reference toggle button.
Gord Dibben MS Excel MVP On Wed, 12 Aug 2009 14:49:01 -0700, Rond wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
I have read of this toolbar but there is no such toolbar that I recognize.
"Gord Dibben" wrote: On the Recording Toolbar there should be a Relative Reference toggle button. Gord Dibben MS Excel MVP On Wed, 12 Aug 2009 14:49:01 -0700, Rond wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
I have never used 2000 but in other versions, including 97, there is a "Stop
Recording" Toolbar that should pop up when you hit ToolsMacroRecord New Macro. You might have closed yours using the "X" when recording. This will stop it from popping up. Go to ToolsCustomizeToolbars and checkmark the Toolbar. Now record a macro..............Toolbar should pop up. Relative Reference button should be on it. Do not close it using the "X"................use the square "stop" Icon. Gord On Wed, 12 Aug 2009 15:53:01 -0700, Rond wrote: I have read of this toolbar but there is no such toolbar that I recognize. "Gord Dibben" wrote: On the Recording Toolbar there should be a Relative Reference toggle button. Gord Dibben MS Excel MVP On Wed, 12 Aug 2009 14:49:01 -0700, Rond wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
Yes, that's it! It works. Why, why would Microsoft so thoroughly hide this
important function? Thank you. "Gord Dibben" wrote: I have never used 2000 but in other versions, including 97, there is a "Stop Recording" Toolbar that should pop up when you hit ToolsMacroRecord New Macro. You might have closed yours using the "X" when recording. This will stop it from popping up. Go to ToolsCustomizeToolbars and checkmark the Toolbar. Now record a macro..............Toolbar should pop up. Relative Reference button should be on it. Do not close it using the "X"................use the square "stop" Icon. Gord On Wed, 12 Aug 2009 15:53:01 -0700, Rond wrote: I have read of this toolbar but there is no such toolbar that I recognize. "Gord Dibben" wrote: On the Recording Toolbar there should be a Relative Reference toggle button. Gord Dibben MS Excel MVP On Wed, 12 Aug 2009 14:49:01 -0700, Rond wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to record macro with relative addressing in Excel 2000
MS did not hide the Toolbar.
You disabled it by closing with the "X" Gord On Wed, 12 Aug 2009 19:08:01 -0700, Rond wrote: Yes, that's it! It works. Why, why would Microsoft so thoroughly hide this important function? Thank you. "Gord Dibben" wrote: I have never used 2000 but in other versions, including 97, there is a "Stop Recording" Toolbar that should pop up when you hit ToolsMacroRecord New Macro. You might have closed yours using the "X" when recording. This will stop it from popping up. Go to ToolsCustomizeToolbars and checkmark the Toolbar. Now record a macro..............Toolbar should pop up. Relative Reference button should be on it. Do not close it using the "X"................use the square "stop" Icon. Gord On Wed, 12 Aug 2009 15:53:01 -0700, Rond wrote: I have read of this toolbar but there is no such toolbar that I recognize. "Gord Dibben" wrote: On the Recording Toolbar there should be a Relative Reference toggle button. Gord Dibben MS Excel MVP On Wed, 12 Aug 2009 14:49:01 -0700, Rond wrote: Attempt to record a macro with relative addressing. I have R1C1 option checked in Toolsoptionsgeneral. After recording a simple macro, addressing is always absolute. I do not know how to program in visual basic. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I record a macro in Excel 2000? | Excel Discussion (Misc queries) | |||
| How to convert relative to absolute addressing instantly in Excel | Excel Discussion (Misc queries) | |||
| How do I record a macro with relative cell addresses? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Linear Mode
