Todd,

A similar test worked fine for me.

Check the obvious.
- the workbook is opne
- it is called B2B Master.xls
- the worksheet is called Marked IDs All Regions

--
HTH

Bob Phillips

"Todd Huttenstine" wrote in message
ups.com...
Below is what I am using for my rowsource and I still keep getting an
error. What am I doing wrong?


ListBox1.RowSource = Workbooks("B2B Master.xls").Worksheets("Market IDs
All Regions").Range("A2:D14").Address