Is it possible to use merged cells in a ListFillRange property assignment for
a listbox or do I have to create a new list without the merges to populate my
listbox?
Also how do you use a row list in a listbox? In other words, I have a list
in Range("D3:AA3") that I want to use in a listbox.

While you can use merged cells, this makes for a very ugly list, full of
empty rows, especially if you have a horizontal list, using horizontally
merged cells! I don't know why people merge cells, other than to see
content! Excel certainly does not have to "see" the content. You can have a
12 digit name in a column showing 3 digits, and Excel reads it correctly
every time.

To use a horizontal list, merley define that horizontal list in the Source
box eg A1:K1

--
HTH

Kassie

Replace xxx with hotmail


"Ayo" wrote:

Is it possible to use merged cells in a ListFillRange property assignment for
a listbox or do I have to create a new list without the merges to populate my
listbox?
Also how do you use a row list in a listbox? In other words, I have a list
in Range("D3:AA3") that I want to use in a listbox.