Thread: refer to dynamic range in closed workbook with ADO
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MattShoreson[_18_] MattShoreson[_18_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote