I am trying to use a named range as the source of items for my listbox. This line creates the named range. It's in a standard module in my workbook.
Workbooks("Sports17.xlsm").Names.Add Name:="data_file_list", RefersTo:="=OFFSET('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$B$1,1,0,count('[" &...