+ Reply to Thread
Results 1 to 3 of 3

Fixed grid reference, possible?

  1. #1
    Beta
    Guest

    Fixed grid reference, possible?

    I have an application where I need to point absolutely to a fixed cell and
    even if the content of that cell gets moved, still the pointer remains on
    that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
    I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
    content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
    a way to have A2 still point at $A$2.
    Thanks!



  2. #2
    Beta
    Guest

    Re: Fixed grid reference, possible? correction

    I have an application where I need to point absolutely to a fixed cell and
    even if the content of that cell gets moved, still the pointer remains on
    that cell. As an example suppose I have 1 in the cell A1. Now in the cell A2
    I write =$A$1. Of course a 1 is the content of A2. But if now I drag the
    content of A1 to B1 the cell A2 now points to =$B$1. What I'm looking for is
    a way to have A2 still point at $A$1.
    Thanks!



  3. #3
    Chip Pearson
    Guest

    Re: Fixed grid reference, possible?

    Use the INDIRECT function. E.g.,

    =INDIRECT("A2")


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Beta" <beta@private.000> wrote in message
    news:6QcEd.8693$wZ2.5117@newssvr13.news.prodigy.com...
    >I have an application where I need to point absolutely to a
    >fixed cell and even if the content of that cell gets moved,
    >still the pointer remains on that cell. As an example suppose I
    >have 1 in the cell A1. Now in the cell A2 I write =$A$1. Of
    >course a 1 is the content of A2. But if now I drag the content
    >of A1 to B1 the cell A2 now points to =$B$1. What I'm looking
    >for is a way to have A2 still point at $A$2.
    > Thanks!
    >




+ 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