adding column to workbook with macros

[Tim]

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

 

[Guest]

Macros will not auto adjust.

 

[Gord Dibben]

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

 

[JP]

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