I said I didn't need an Index number in my data, but turns I do with this approach, as the Value property in the dropdownentry collection must be unique. I had some situations in my data where although I had a unique identifier in the element I'm choosing to use as the Text, it turned out that some off the rows contained an identical set of attributes that I was attempting to use as the value.

So, I added a column in the spreadsheet's range and populated it with a =row() formula to generate a unique identifier. That way my pipe delimited strings end up being unique, and I just never use that last element.

Thanks for the explanation on the codes and your sampling of functions. That helps me understand better.

Most times in these forums people call me Shred, but in other worlds I go by Keith.