Adding and Deleting Rows with a Hide Row Macro CheckBox

[jason68691]

Hello

I currently have the following Macro for one of my many checkboxes in 2007 Excel:

Please Login or Register  to view this content.

It works perfectly until additional rows are added/deleted before the indicated rows in the code (It changes the number sequence in the workbook). The number sequence stays the same in the code which means I am now hiding rows either before (delete rows) or after (insert rows) the intended rows I want to be hidden. Is there a way to change the above code to remain with the assigned rows regardless of the adding/deleting of rows before it?

[Kenneth Hobson]

Name the range.