View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default change in colunms of sheet- and macro ?

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