I have a spreadsheet the uses 4 four ranges of data to select the contents of the data validation list in a column on my main data sheet via an indirect function. These ranges are kept on a separate tables sheet in the same workbook and filter selections from another large table. The range tables originally had 9 columns but I have expanded them to have 20 columns. These extra columns are working fine on the data table sheet and pick up the correct data selections as required. The problem I have is that the indirect link in the data validation is not picking up the expanded columns so it still only selects from columns 1-9 in each range rather than 1-20. All the headings in the data range tables are the same format so I don't know what to do to correct this. I have attached some images that may help. Any advice would be gratefully received