I need to define a named range where the size of the named range is linked back to cell in the spreadsheet. This will let my user define where the range starts and stops by simply inputing values into these cells. I tried using the indirect function to define the range. For example, I entered =INDIRECT("Sheet1!" & "$I$" & A1 & ":$I$23") t define the range, with the hopes that I could then enter a number in cell A1 which would deterime which row the named range starts on. But it didnt work. Any ideas would be greatly appreciated.