View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean[_5_] Sean[_5_] is offline
external usenet poster
 
Posts: 4
Default 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