List vs Dynamic Range Name

  • Thread starter Thread starter dee
  • Start date Start date
D

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!
 
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.
 
Hi,

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


--
Thanks!

Dee


T. Valko said:
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.
Click to expand...
 
Back
Top