In the 97 version of Excel you could click the relative reference button (I
think that is what it was called) and the macro would recognize and update
itself automatically if the spreadsheet itself changed after the macro was
created. (i.e. vb programming says select cell B2 and clear the contents, you
insert a row above row B, so B2 is now B3 but your macro still wants to clear
B2.)

How do you do this in Excel 2003?
Thanks.