I'm surprised this topic hasn't been posted before (or maybe my searches didn't hit them), but it's fairly simple:

I've defined a number of rows in a named range.

When I insert or delete a row within that range, I find that excel automatically adjusts the named range to include/remove the cells I insert/delete.

I DO NOT want this. I wan't the reference to my named range to REMAIN THE SAME no matter how many rows I insert or delete.

I am not using code to define these names.

Thanks,

Jerry