Automattically adjust code when rows or columns are added

Hi!

I'm seeking to get the following; I have a code for when a checkbox is checked or unchecked; rows hide and unhide. However; when I add a row somewhere in the spreadsheet, the code doesn't automaticcaly adjust. I have the following code;

Please Login or Register  to view this content.

So when I add a row; row 47 becomes 48 for instance. This way the code hides the wrong cell!

Does anybody have any ideas on how to make the code automatically adjust accordingly??

Would be much appreciated!

Hi Tulipo
Try using Named Ranges...it works for more than one row but will NOT work for single row ranges (65:65). For example

Please Login or Register  to view this content.

Hi Tulipo
Have you tried Named Ranges...did it not work for you?

If you create a Defined Name for a range, whenever you insert or delete rows the Defined Name will update automatically to include the new row positions. To do so:

On the Formulas ribbon click Define Name. Next to 'Name' type a name for the range, e.g. myrange. Next to 'Refers to:' type (or copy/paste) the following formula:

=Sheet1!$47:$54,Sheet1!$65:$65,Sheet1!$67:$70,Sheet1!$82:$93,Sheet1!$96:$116,Sheet1!$118:$119,Sheet1!$125:$131,Sheet1!$134:$138,Sheet1!$146:$147

Click OK. You can then change your code to the following, and it should adjust when you insert or delete rows.

Please Login or Register  to view this content.

Change the sheet name as necessary.