You mean it is recording in R1C1 format?

I believe that is how it does it in Excel 2002.

--
Regards,
Tom Ogilvy


"DMOB" wrote in message
...
When I record macros in excel the macro is being recorded
in visual basic language that is different from what I am
used to seeing. The macro will become messed up if I add
or change rows in the excel spreadsheet - since the macro
will not update the cells it references since visual
basic does not HARD CODE the cell - it uses a relative
navigation system to locate cells or worksheets. This
never happened when I used Excel before in a previous
Company, but I don't know what version it was. Right now
I am using Excel 2002 SP2.