Hi All,

On Excel 2000 when you record a macro there is a button that allows you to
record a macro that is in reference to the current cell position as opposed
to referring to specific cells when you record a macro.

How do you do this in excel 2003?

Is there a different method or am I missing the obvious.

Regards

Andi

I THINK you're missing the obvious -- the same button is present for
recording relatively in xl2003 as in xl2000.

"Andibevan" wrote in message
...
Hi All,

On Excel 2000 when you record a macro there is a button that allows you to
record a macro that is in reference to the current cell position as
opposed
to referring to specific cells when you record a macro.

How do you do this in excel 2003?

Is there a different method or am I missing the obvious.

Regards

Andi

Yep - It is the "Stop Recording" toolbar - this is not selectable unless you
are recording a macro - as a result I couldn't find it.

Doh

"Bob Umlas" wrote in message
...
I THINK you're missing the obvious -- the same button is present for
recording relatively in xl2003 as in xl2000.

"Andibevan" wrote in message
...
Hi All,

On Excel 2000 when you record a macro there is a button that allows you to
record a macro that is in reference to the current cell position as
opposed
to referring to specific cells when you record a macro.

How do you do this in excel 2003?

Is there a different method or am I missing the obvious.

Regards

Andi