I have a bunch of data indicators arranged by Months, quarters and half years. The indicators run across the page and the quarters line up with the months (three cells merged) as do the half years (six cells merged). Named ranges on the monthly column works fine but when I try to use named ranges on the quarterly cells it gets really confusing. I will get the function to grab the last four in the row but when I enter another one the range doesn't move. =OFFSET(Sheet1!$A$1,0,COUNTA(Sheet1!$A$1:$AB$1),1,4). If I just enter the =COUNTA(Sheet1!$A$1:$AB$1) into a cell it will correctly return the number of cells(not the true number of cells that have been merged). Am I going to be able to do this with merged cells. I have a lot of work into the existing document so I would hate to start over. Thanks