adding column to workbook with macros

  • Thread starter Thread starter Tim
  • Start date Start date
T

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
 
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
 
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
 
Back
Top