Hi Garry,

Am Wed, 14 Aug 2013 17:37:03 -0400 schrieb GS:

Interesting! I get back exactly what's in the DV refedit box.

yes, you always get back what is in the refedit box.
Hard coded the items or the range name (=myList) or the range itself
(=$H$1:$H$5)
You can check for the "=" to see if you can work with the items at once
or you have to work with the ranges.

But xl2010 or xl2013 you could get e.g. =Sheet2!myList or
=Sheet3!$A$1:$A$10 and you have to do a little workaround


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