Hi,

I want to fill a combo box (Microsoft Forms combo that is) with a list from
a named range.

The named range has merged cells in it.

On the Ozgrid site he http://www.ozgrid.com/Excel/DynamicRanges.htm they
explain how to use dynamic named ranges in case the range will expand.

But when I set the ListFillRange of the combo box to my named range it only
finds the first one.

Does it not work with merged cells?

thanks

Follow up:

It turns out that it treats all the rows as blank entries in a named range
when there are merged cells.

So instead of 4 entries from 134 cell,s I get 4 text entries and 130 blank
entries added to the combo box.

Is there any way to make it ignore blanks?

thanks

"Philip" wrote:

Hi,

I want to fill a combo box (Microsoft Forms combo that is) with a list from
a named range.

The named range has merged cells in it.

On the Ozgrid site he http://www.ozgrid.com/Excel/DynamicRanges.htm they
explain how to use dynamic named ranges in case the range will expand.

But when I set the ListFillRange of the combo box to my named range it only
finds the first one.

Does it not work with merged cells?

thanks