Another typo:

..List(.ListCount - 1, 1) = Cells(i, "B").Text

(.listcount, not .listindex)

Sorry.

And make sure you're not using the .rowsource -- either in code or in the
properties menu.


Eddie_SP wrote:

Hi Dave,

One error:

Runtime Error 380 - Could not set the list property. Invalid property array
index.

Do you know what that means?

Thank you.

Eddie !

--

Dave Peterson