You can only use the rowsource on a contiguous range.

You will need to add the items using AddItem and then the list or column
commands.

--
Regards,
Tom Ogilvy

Dave Baranas wrote in message
om...
I need to fill up a listbox with columns that are not next to each
other on a sheet

I have used main.lstbox.rowsource = "Sheet1!A2:R181"

then I tried

main.lstbox.rowsource = "Sheet1!A2:F181,Sheet1!I2:T181"

At least that one got by the compiler but I do not get the expected
results instead I get a blank list

I tried using a post where you make a union of ranges but that didn't
work out either.

I have a sheets with 200 columns across and depending on what page the
user is looking at I am tried to load up a list box with different
columns. If I could load up a listbox rowsource from columns on
diferent sheets that would just be awesome!

Any help on this one would be very appreciated

Regards,

Dave Baranas