How do I record a macro with relative cell addresses?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When running a macro to enter date in several different cells, the entries
always are made in the original cell addresses that were used during
recording. I want to record a macro that allows "relative" cell movement
instead of "absolute" (with reference to the starting cell). I seem to
recall there was an option available to do this at one time, but I can't
recall what it was.

I'm using MS Office Excel 2003.
 
What you need is the Stop Recording toolbar, it has the relative button.
It's a little hard to find:

1. start recording a dummy macro
2. pull-down View > Toolbars > and make sure the Stop Recording bar is checked
3. closeout the dummy macro.
 

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

How to record macro with relative addressing in Excel 2000 3
The Relative Macro 6
How do I change a macro to use relative cell addresses? 2
Excel 2003 macros set relative cell references 7
Pasting cell contents into a macro 1
Copying & Pasting with recorded macros 9
Change a cell reference from relative to absolute 2
Macro - insert slashes into a cell 1

Back
Top