Macro recorder

[Guest]

How can I use relative references in my macro when I
record a macro with the "record"-tool?

 

[Peter Atherton]

-----Original Message-----
How can I use relative references in my macro when I
record a macro with the "record"-tool?
.

Use the arrowkeys in a formula this will give you
something like this

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

Regards
Peter

 

[Jim Rech]

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.