Expanding range
 

Cell A1 contains: =COUNTA($A16:$A109)

To insert an empty cell, I put the cursor at cell A16 then click INSERT and "Shift cells down" and the formula changes to: =COUNTA($A17:$A110)

How can I write the formula in cell A1 so, after the insert, it automatically reflects the expanded range $A16:$A110?

Expanding range
 

GARYWC wrote:

Cell A1 contains: =COUNTA($A16:$A109)

To insert an empty cell, I put the cursor at cell A16 then click INSERT
and "Shift cells down" and the formula changes to:
=COUNTA($A17:$A110)

How can I write the formula in cell A1 so, after the insert, it
automatically reflects the expanded range $A16:$A110?

Change $A16 to $A$16.

--
I do believe that right makes might and that if I am wrong,
10 angels swearing I was right would make no difference.
-- Gerald Ford