On Sun, 25 Nov 2012 09:45:03 -0000, Victor Delta wrote:

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?

Don't use a cell reference; use a defined name. Defined names do
automatically update when you insert or remove rows or columns.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...