How to record macro with relative addressing in Excel 2000

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.
 
R

Rond

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...
 
G

Gord Dibben

On the Recording Toolbar there should be a Relative Reference toggle button.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Record Macro Toolbar 1
WORD VBA Search and switch to advanced ... 1
How to make scroll bar permanently visible, Word 365 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0

Top