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