View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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