ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Naming fixed range versus a List (https://www.excelbanter.com/excel-programming/428772-naming-fixed-range-versus-list.html)

[email protected]

Naming fixed range versus a List
 
I posted this question as an addendum to another thread without
response, so I'm hoping that it's just because it was hiding under
the
wrong thread.

When I name a range that happens to correspond to a list, the name
becomes attached to the list rather than the underlying range. That
is, when the list size changes due to row addition/deletion, the
range
corresponding to the name also changes.

This is great for most occassions, but I was wondering if there are
circumstances under in which the name would apply the a fixed range
rather than a corresponding list?

I'm not asking because that's what I want to do at the moment (though
you never can tell, it might be useful in the future). I'm asking so
that I can be assured that the naming of a range that corresponds to
a
list will /always/ attach the name to the list. If that's the case,
no need to worry about the alternative happening due to circumstances
that one doesn't know about.


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com