List vs Dynamic Range Name
 

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

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

List vs Dynamic Range Name
 

Hi,

Thanks for your response. It pretty much backs up what I thought!


--
Thanks!

Dee


"T. Valko" wrote:

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