Thread: Expanding range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default 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?