use another set of cells to build a contiguous range (containing formulas
point back to your original ranges) and use that as the rowsource.

or use AddItem

--
Regards,
Tom Ogilvy

"VJ" wrote in message
...
I have range whose address is like: $A$25:$D$26,$A$43:$D$47.

I need to display only col A and col B in a combo box with two columns in
combo box.

I have used rowsource property but it gives me error.

Help would be appreciated.

Thanks