Need hidden range to "move" when rows are added or deleted....I'm close but no cigar.

Good evening. I've created a form to track various staffing info and patterns that will be updated on a regular basis. I'm including a date and number "calculator" to assist the user when updating the form. The first two sheets are similar but for different programs. The third sheet has info I'm referencing (data validation) on the first two sheets.

When I started the form I attempted to build the "calculator" in a userform but I got in over my head really quickly so I opted to build it in the worksheets. Everything works as expected unless I "hide" the range name I've given to the calculators on sheets1 and sheets2. I wish to give the user the option to hide calculator when it's not in use, otherwise I would be all set.

So, the code I'm using to hide/show the "calculator" on sheets1 and sheets2 is listed below:

Please Login or Register  to view this content.

Questions:

1) Would the userform route be cleaner and more efficient?
2) What am I missing in my code that would allow the named range (i.e. my "calculator") to move up or down when I add or delete rows?

Thanks for weighing in with your thoughts and suggestions.

P.S. I've attached the latest version of the form I'm working on. The password, if needed, is "j". Thanks.

Matthew