| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to dynamic range in closed workbook with ADO
I have a listbox on a userform. Am trying to read a named range in a closed workbook, and then retur the range to a listbox. If it's a static named range then its fine. If it's a dynamic name range(offset etc.) then the range cannot be read into the control. Any ideas anyone? Cheers, matt -- MattShoreso ----------------------------------------------------------------------- MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347 View this thread: http://www.excelforum.com/showthread.php?threadid=37703 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make camera object refer to dynamic range | Excel Discussion (Misc queries) | |||
| Can you make a chart's data *always* refer to a dynamic range name? | Charts and Charting in Excel | |||
| Help - Does value exist in range of CLOSED workbook? | Excel Worksheet Functions | |||
| How to copy a range to a closed workbook | Excel Programming | |||
| How do you refer to a dynamic named range? | Excel Programming | |||
![MattShoreson[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
