I am relatively new to this myself.

From what I have read, the list must be in the same worksheet. I
usually put my lists in row one as a horizontal list. Since a
worksheet can have 256 columns, this gives room for a fairly large
list, or several smaller lists. I have used as many as three rows for
my lists. I then hide that row or those rows.

For instance I will use the list $A$1:$Z$1 even though I myght only
have 15 items in the list. Then I can add up to 9 more without having
to change the list reference.

I hope this helps?


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=487220