Problem Recording Macros in Excel

[DMOB]

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.

 

[Tom Ogilvy]

You mean it is recording in R1C1 format?

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

 

[Guest]

hi,
A recorded macro is at best a good starting point for the
real macro. once recorded, you have to go into it, edit it
to make it genearic so that it will handle different data
sizes.
if you are not familar with vb, you might post your
recorded macro, explain what you are trying to do and
someone will help you edit it to your needs.
if you wish to look up a little on vb try
http://www.exceltip.com/excel_links.html
http://www.exceltip.com/tutorial/garrison/
http://www.j-walk.com/ss/books/xlbook25.htm
www.mrexcel.com
http://www.cpearson.com/excel/events.htm