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