It depends on the behavior you want, which you have not explained. If you moved the entire column, the named range definition would move to follow it.
It depends on the behavior you want, which you have not explained. If you moved the entire column, the named range definition would move to follow it.
Entia non sunt multiplicanda sine necessitate
That's what I want. It never occurred to me that someone might want a different behavior. I anchor the range to the column heading ($B$12), but the data actually starts in $B$13. That way if a row gets inserted below $B$12, the range still starts in $B$13.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks