Dear All,

I hope you are all well.

I have two NamedRanges that are lists of different departments.

What I need, is to have a ComboBox with both NamedRanges merged on the Drop Down list.

The code I have, it lists one of the named ranges and hides the cells market as "Empty" as follow:

Private Sub ComboBox1_DropButtonClick()

Dim c As Range

With Range("DU")
    For Each c In .Columns(1).Cells
        If c.Value <> "Empty" Then ComboBox1.AddItem c.Value
    Next c
End With
End Sub
As you can see, one of the named ranges is "DU" and I need to add another into the list (named range as "FU").

Is it possible to "merge" it into one ComboBox?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe