List vs Dynamic Range Name
Advantage:
With a List, you don't have to create a (possibly complex volatile) formula
for the defined range.
Disadvantage:
Lists are only available in Excel versions 2003 or greater.
--
Biff
Microsoft Excel MVP
"dee" wrote in message
...
Hi there,
I'm well-versed in both of these methods and am wondering if there is a
compelling reason to use one over the other.
Converting my regularly named range to a List allows me to add data and
have
the named range expand. So does using a dynamic range name.
Any thoughts of why (or why not) one or the other?
Thanks!
--
Thanks!
Dee
|