retrieve data from a defined name with multiple rows

[feldspar]

I have copied a Word table into an Excel spreadsheet and created a defined name to refer to it. There are 6 columns and 50 rows in the defined name called ScheduleList. I want to use each row in ScheduleList to populate a combobox in the same sheet. I am thinking of doing something like:

For each row in ScheduleList
  schedCombo.ControlFormat.AddItem ScheduleLIst(row, 1) + ScheduleList(row,2)

next row

What is the best way to accomplish this?

 

[JoeMo]

Cell values in the named range "ScheduleList" can be referenced like this:

Range("ScheduleList")(1,1) is the upper leftmost cell

Range("ScheduleList")(50,6) is the bottom left-most cell

So in general Range("ScheduleList")(i,j) where i is the relative row in the named range and j is the relative column in the named range.

 

[feldspar]

Thanks Joe. This did the trick.

 

[JoeMo]

Thanks Joe. This did the trick.

You are welcome - thanks for the reply.