Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 formula, multiple reference range | Excel Discussion (Misc queries) | |||
Vlookup using a reference to a named range?(Excel 2000) | Excel Discussion (Misc queries) | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
How do I use a name in a range reference in excel? | Charts and Charting in Excel | |||
How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions |