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