Both your solutions work on the sheets you attached, neither work in my sheet that does have E18 as the first cell in the range. I must be doing something really stupid to throw it off? I am just gonna attach the sheet quick (with most of the stuff pasted over by an unrelated soccer spreadsheet, yet still with the same problem).academy_reserves_index.xlsx