Quote Originally Posted by dborchardt
That helps. I am now seeing the pattern. Here is what seems to work:
=OFFSET(Sheet1!$A$1,0,COUNTA(Sheet1!$A$1:$IP$1)*3-9,1,7)
When I finially figured out that counta is only counting the cells that have someting in them and offset is counting all cells regarless of merged status, it all came together.Thanks
HI

=CountA and =CountBlank should total the cells in the range, occupied or not.

Good to see it worked for you, and thanks for the response.
---