Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 formula, multiple reference range Lisa Grant Excel Discussion (Misc queries) 0 January 25th 10 11:01 PM
Vlookup using a reference to a named range?(Excel 2000) Joe Excel Discussion (Misc queries) 4 May 19th 08 06:41 AM
automatic range - named range give me circular reference... George Thorogood Excel Discussion (Misc queries) 0 February 22nd 07 07:53 PM
How do I use a name in a range reference in excel? RicRob Charts and Charting in Excel 2 January 13th 06 01:55 PM
How do I reference and sort a range of numbers in Excel 97? Old Northern Excel Worksheet Functions 3 December 14th 04 03:15 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"