Depends upon how your macro is written.

If hard-coded, they will not adjust.

If relatively-coded they should adjust.


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 09:03:45 -0700, "Tim" wrote:

Sorry just posted to wrong group

If I add a column to an existing workbook/sheets...do I have to recreate
existing macros in that workbook..or will they 'auto-adjust' to the new
column inserted ?

The existing macros work on various columns with different functions

Thanks, Tim