In the same sheet are assigned over 10 Macros with hide rows with different ranges for example : for one macro is Range("314:314,326:343,353:357,368:369,372:376").Select Selection.EntireRow.Hidden = True; for the the other Range("314:314,322:327,334:342,344:346,348:357,368:369,372:376" ).Select Selection.EntireRow.Hidden = True and so on.....
For this reason is important to me how to find a proper way how to make keep the ranges with a row reference in modules automaticlly after adding or removing row/rows because rows will move down or up not by keeping the rows reference for assigned macro. Now everytime i need to go through all 10 macros to change ranges after adding/removing row/rows. it takes a lot of time and a lot of chances to be mistaken.Thanks!
Bookmarks