Hi Garry,

Am Wed, 14 Aug 2013 16:34:46 -0400 schrieb GS:

If the local ref is a local scope defined name then I get that back...
=DVList

in version xl2007 or earlier list on other sheets has to be named with a
GLOBAL name.
xl2010 or later you can refer to a range on another sheet, like
Sheet2!A1:A10
Therefore it is important to know what xl version is used and how is
referred (with name or with a range)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2