Hello:

Does the recorder alway record formula's in R1C1 notation ? Is there anyway
you can change it to A1 notation? Thanks in advance

Ravi

When you record the macro press the relative reference button on the stop
recording macro button. This should be persistent recording to recording.
(Currently it will look pressed which records R1C1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"ravi" wrote in message
...
Hello:

Does the recorder alway record formula's in R1C1 notation ? Is there
anyway
you can change it to A1 notation? Thanks in advance

nope, it doesn't.

The small square next to the <Stop button toggles between R1C1 and A1.

Guys,

Is it me? That button is relative/absolute, not R1C1/A1?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jacob" wrote in message
ups.com...
nope, it doesn't.

The small square next to the <Stop button toggles between R1C1 and A1.

I thought so to Bob -- the button should be relative/absolute refrence -- I
have recorded macros where it switches back and forth and seems to work ?

"Bob Phillips" wrote:

Guys,

Is it me? That button is relative/absolute, not R1C1/A1?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jacob" wrote in message
ups.com...
nope, it doesn't.

The small square next to the <Stop button toggles between R1C1 and A1.

Ah well, if it's us, at least we have company <vbg

Bob


"Polarbear" wrote in message
...
I thought so to Bob -- the button should be relative/absolute refrence --
I
have recorded macros where it switches back and forth and seems to work ?

"Bob Phillips" wrote:

Guys,

Is it me? That button is relative/absolute, not R1C1/A1?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jacob" wrote in message
ups.com...
nope, it doesn't.

The small square next to the <Stop button toggles between R1C1 and
A1.