"Jim May" wrote
How do you get rid of the #NUM! that appears in Col A
and the last select in the Drop-down?

Think you might have missed this part of
Jason's instructions in the construct:
....
Now fill down as many rows as
your list contains elements.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----