Read a named range into an array

I want to take a named range which is in a row consisting of month and year headings, such as "Aug 2007" and read them into an array to be used in a list box. I also want to store the column of each (such as "August 2007" is in column G, "September 2007" is in column F, and so on descending), so I suspect my best way is a two dimensional array. The column value will later be used to refer to all the corresponding fields in that column. I am using a named range because every month it grows by one item, the last month and year that we recorded. The listbox will be in one sheet, the data including the headings are together in another, both in the same workbook. I suspect my best place to put the code is in the WorkSheet:Activate event of the sheet where the listbox is placed.

I started to hack away at this and found myself dealing with too many variables in how to handle; I know that given enough time I will eventually get it but I am asking for help because I would probably waste a week or more when you folks probably know this stuff by heart. If someone could show me how to do this it is very much appreciated.

Thank-you!