change in colunms of sheet- and macro ?

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

Tim R

I have a workbook with 4 sheets that is pretty well set...I have to add one
or two columns to one sheet for some important additional functions...?..do
I have to also rewrite or modify a macro I have to format the sheet...or
will the macro "update" as a result of the column additions.

I have four sheets in the workbook...do I need to update each and every
sheet with the new columns...even though they are only going to be used in
sheet 1 for the macro to work properly on all sheets ?

Thanks, Tim R
 
Hi,
If you have referred to ranges/cells by 'A1' or 'R1C1' notation, you will
have to update your macros by hand. They do not update automatically,
unfortunately. To avoid this problem in future, use named ranges, which do
update automatically when moved by inserted columns/rows
Regards - Dave..
 
Back
Top