| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesnt it change sheet in the macro | Excel Worksheet Functions | |||
| macro to change data in inactive sheet | Excel Discussion (Misc queries) | |||
| Macro to change data in a sheet | Excel Discussion (Misc queries) | |||
| change sheet name macro | Excel Worksheet Functions | |||
| Change macro to paste as last sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
