ComboBox - Listfillrange - dynamic named ranges

[osx99]

I need to use a combo box to whose selections change based on te results of another cell.

The following formula works fine with data validation on named ranges but I can't get it to work in the combobox listfillrange

=INDIRECT(SUBSTITUTE(b19," ",""))

When I enter the above formula it just resets the listfillrange value to blank

I need to keep the combo box set up. Is this possible?

 

[GlennUK]

In that case, are you happy with having to use Event code?

Because I can't think of what could be causing your problems, without actually seeing the workbook. So you'd have to send it to me at glenn dot bamford (at) hotmial dot co dot uk ( I hope you can decipher that ).

Cheers, Glenn.

Beauty is in the eye of the beerholder.