Hi. I have this little program where you can add items to an index (it's do with foods). So you select the food category the food belongs to then the macro will put it in the respective place in the index (under the correct category heading and in alphabetical order). I then draw from this index on another sheet using drop down boxes. The first drop down box will name the category, the second box you can choose the food type. If the index were to stay fixed then there would be no problem using the indirect function as the range of cells will be of fixed size, however the range of cells is constantly changing. I have noticed that if you insert rows in between other rows in a named range then the name range will expand automatically. However if you add a row onto the end of the range, it will be outside the name range. Any ideas (layman) terms how to tackle this problem? Thanks!