How to record macro with relative addressing in Excel 2000

  • Thread starter Thread starter Rond
  • Start date Start date
R

Rond

Attempt to record a macro with relative addressing. I have R1C1 option
checked in Tools>options>general. After recording a simple macro,
addressing is always absolute. I do not know how to program in visual basic.
 
Rond said:
Attempt to record a macro with relative addressing. I have R1C1 option
checked in Tools>options>general. After recording a simple macro,
addressing is always absolute. I do not know how to program in visual basic.
Click to expand...
 
On the Recording Toolbar there should be a Relative Reference toggle button.


Gord Dibben MS Excel MVP
 
Back
Top