Maybe if you swap the order...

With Me.lstMembers
.ListFillRange = ""
.Clear

But I was just trying to make sure you didn't assign a range address to the
listbox. If you didn't do that, then this line of code isn't really necessary.

bach wrote:

Dave Peterson,

Thanks for you help with this, I have copied the code and it does not
like *.listfillrange*. I have commented this bit of the code out and
it seems to populate the listbox.

I will have to play with the code to ensure all the colums they want
are included inside the list box.

If I have any issues will post back.

P.S
-Would you have an idea why it does not like *.listfillrange* and is it
required.-

--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468634

--

Dave Peterson