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
Bookmarks