I have a combo box, and the ListFillRange contains a Range (CUST_LIST) which referes to a list in another workbook.
I am trying to defing this range without having to open up the other workbook. Is this possible?
Yes... So long as you have something like a list reference to the Cells, or something comparable ( darn... my workbook with what I used is not here, ah well... someone will no doubt come up with the appropriate linkage)
Actually.... this is one example of how to access a closed book :