Hi Mike

I miss one )

And Cells use the cells on the activesheet now so you must use it like this

Sheets("Sheet2").Range(Sheets("Sheet2").Cells(1, 1), Sheets("Sheet2").Cells(10, 3)).Address



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Mike Samyn" wrote in message ...
For a given form can I reference multiple sheets within a workbook? Here is
what I tried to do but it failed on the second ComboBox.

...
ComboBox1.RowSource = Sheets("Sheet1").Range(Cells(1,1),Cells(10,3).Addr ess
....
....

ComboBox2.RowSource = Sheets("Sheet2").Range(Cells(1,1),Cells(10,3).Addr ess


Thanks
Mike