Should Be Easy - Relative Macros

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
I THINK you're missing the obvious -- the same button is present for
recording relatively in xl2003 as in xl2000.

"Andibevan" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>