+ Reply to Thread
Results 1 to 4 of 4

Inserting a row does not increment reference in cell

  1. #1
    Registered User
    Join Date
    03-15-2008
    Posts
    2

    Inserting a row does not increment reference in cell

    I have the following worksheet

    in cell A19 - =A18
    in cell A20 - =A19
    in cell A21 - =A20
    in cell A22 - =A21

    if I insert a new row in between A19 and A20, I get

    in cell A19 - =A18
    in cell A20 -
    in cell A21 - =A19
    in cell A22 - =A21
    in cell A23 - =A22

    Previous Cell A20, which becomes A21 does not increment the cell reference to A20 - it stays at A19. The other cells increment the cell reference as expected.

    How do I get the reference to update?

    TIA
    Dave

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Select cell A2.

    Insert > Name > Define, ptrAbv Refers to: =A1 (no $ signs).

    Then change the formula in all those cells to =ptrAbv

  3. #3
    Registered User
    Join Date
    03-15-2008
    Posts
    2

    Thank-you, thank-you, thank-you....

    Who knew such a simple thing would be so tricky. You have saved me countless hours of frustration and depression.

    Thanks

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Named ranges are very handy, you're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1