Reference to a range in an Excel Add-In
 

Hello,

Can someone please tell me if it is possible to use a
range in an installed .XLA file as the ListFillRange of a
combobox?

I have defined a range in my normal spreadsheet which
refers to the said range by using MyXLARange
= "=PDFInfo.xla!DBSeansTestRange". The ListFillRange of a
combobox is then set to MyXLARange. The result is the
combo box displays a garbled list of entries which,
although apparently correct in row number, repeats only a
few of the row entries time and time again.

Any ideas on this would be greatly appreciated.

Sean