| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding a range | Excel Programming | |||
Threaded Mode
