![]() |
ListFillRange linked to named range in a closed remote file
I'm trying to use the ListFillRange to populate listbox controls in a
workbook for remote distribution. For maintenance reasons I'd like to keep the list sources in a central location rather than farming them out with each copy of the file. The values available in most listboxes changes based on choices made earlier, so the user display is highly fluid. Although I can use ListFillRange dynamically when the file is open, for the life of me, I can't figure out the correct syntax to refer to the source file (using UNC structure) that will work. If anyone can help I would greatly appreciate it. Thanks! |
All times are GMT +1. The time now is 07:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com