When you record a macro normally it will record the cell references by their
address. When recorded with relative referencing then it will record how you
moved relative to some starting point.

To switch it on when you start recording a macro the Stop Recording tool bar
should come up (if not then repy back and we can get it back on for you).
There are 2 buttons on the bar. The first is Stop (Blue Square). The second
is for Relative Referencing. Click this button and the macro will record with
relative references...
--
HTH...

Jim Thomlinson


"Liz" wrote:

Hi,

What does it mean to record the macro with relative addressing switched on?
And how can I switch it on.

Thanks
Liz