Macro to insert rows within a specified range

I am using the below code for inserting rows in my worksheet. Rows 1 to 6 in the worksheet contain cells that have either label (headings) or notes. I do not want any row inserts to happen in this range.

How should the below code be modified to accommodate this?

Thanks in advance
AGS

Please Login or Register  to view this content.

Hi AGS

You could do that a couple of ways. You could lock those rows then protect the sheets; however, you'll end up with an ugly error message.

You could add this to your code

Please Login or Register  to view this content.

I'm certain there are other ways do accomplish this.

John