If your last column was C and you wrote "Range(Selection,
Selection.offset(3,1)).select" intending to select all the way to the
rightmost cell, your macro would then have a logic error once you
inserted a column.

But if you wrote "Range(Selection, Selection.end(xltoright)).select"
then it would always select the rightmost cell regardless.


HTH,
JP


On Nov 6, 11:03 am, "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