retrieve data from a defined name with multiple rows

feldspar

New Member
Joined
Feb 25, 2016
Messages
5
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:

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

next row

What is the best way to accomplish this?
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,388
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,483
Members
414,146
Latest member
marginmakerb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top