View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
rylo[_5_] rylo[_5_] is offline
external usenet poster
 
Posts: 1
Default Populate Combo Box with Values from CSV File


Hi

I'm pretty sure you need to nominate the sheet for the range.


Code:
--------------------
myArray = Workbooks("Master.csv").sheets("master").Range(Cel ls(1, 1), Cells(cnt, 1)).Values
--------------------


I don't know what your sheet name is so I've defaulted it to master.

HTH

rylo


--
rylo
------------------------------------------------------------------------
rylo's Profile: http://www.thecodecage.com/forumz/member.php?userid=28
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29399