List vs Dynamic Range Name

[dee]

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!

 

[T. Valko]

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.

 

[dee]

Hi,

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


--
Thanks!

Dee

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.