Hi,

I have a combobox on my worksheet. I also have a named range called "SSC" which contains the formula:
=ADDRESS(4,42,1,TRUE,"School Summary")&":"&ADDRESS(MATCH(Data!$B$1,'School Summary'!$AP$1:$AP$6,0),42,1,TRUE)

When I type SSC into the listfillrange property of the combobox it automatically clears it to blank and won't populate the combobox.

As a test, I removed the above formula from the named range and put it in a worksheet cell, and then changed the formula in the named range to the indirect function (pointing at the worksheet cell with the formula). The listfillrange worked with this method.

Does anybody know why the combobox listfillrange is behaving like this? Does it not accept named ranges which use certain functions?

Thanks

Ant