I have a VBA macro in an Excel spreadsheet which includes a cell reference
say AX49. Of course, when I insert new columns/rows etc, the reference does
not update.

Is there any way I can write the reference in the macro so that it will
automatically update?

TIA

V