Macro recorder

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

Guest

How can I use relative references in my macro when I
record a macro with the "record"-tool?
 
-----Original Message-----
How can I use relative references in my macro when I
record a macro with the "record"-tool?
.
Click to expand...
Use the arrowkeys in a formula this will give you
something like this

ActiveCell.FormulaR1C1 = "=RC[-3]*RC[-1]"

Regards
Peter
 
Click the "Relative Reference" toolbutton (the second toolbutton) on the
Stop Recording toolbar, which should appear when you start recording.

If it doesn't appear that would be because it was manually closed at some
point when a macro was being recorded. To remedy that select in under View,
Toolbars while recording a 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

Record Macro Toolbar 1
How to record macro with relative addressing in Excel 2000 3
My excel macro recorder no longer shows up when recording macro 3
Excel 2007: Help creating a macro that will run Solver? 3
Access Automatically Send a notification email once a record is added 0
Display Macro Recording Tool Bar 1
HELP! Record Macro in TOOLS > MACRO is gone! 3
Pasting cell contents into a macro 1

Back
Top