Attempting to exlude the ability to add a row outside of a named range

[Turtleman10]

I have a macro that inserts rows. The problem I am having is that I want to limit where they put the rows to an area. The code I was attempting to use was this

Please Login or Register  to view this content.

and it does not work. Any ideas?

[Norie]

Intersect returns a range or Nothing, not True or False.

This will check if the active cell is in 'AcceptableArea' and if it is execute the insert row code.

Please Login or Register  to view this content.

[Turtleman10]

That worked great thanks