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.

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.

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.

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.

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.

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.

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.