Problem with Dynamic Named Range
 

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

Problem with Dynamic Named Range
 

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