Results 1 to 8 of 8

Absolute cell references...changing?

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Warrington, England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Absolute cell references...changing?

    Hi, just a quick question really, I have a feeling it can probably be resolved quite quickly but I just don't know how.

    Basically, I have a formula containing absolute cell references, but whenever I insert a new row into the table that the reference is looking at, the cells bound by the absolute reference change.

    I thought the point of using absolute cell references is that they don't change?

    Anyway, is there some way around this, to avoid the cell reference changing when a row is inserted?

    Thanks in advance for any help.
    Last edited by Dharrison8; 03-10-2010 at 04:46 PM.

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