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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Help to create a macro 2
Macro to copy value in field and insert it into filter 2
Macro to affect all sheets 3
Sheet tab names change automatically 3
Select dynamic data in 2 columns, and repeat macro to next sheet 2
2003 macros 2
automatic sheet selection 2

Back
Top