Help with INDIRECT()


Hello,

I'm trying to keep my references when I drag and drop from one cell to
another so i'm using INDIRECT("D7") for instance. Thing is i want to
drag fill the function but i want D7 to change dynamically, for
instance INDIRECT("D8") or INDIRECT("E7")

Thanks in advance. :)


--
Sophat
------------------------------------------------------------------------
Sophat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25926
View this thread: http://www.excelforum.com/showthread.php?threadid=393019

.

Relevant Pages

  • Re: Auto Fill
    ... Row references won't change as you drag across, ... "About cell and range references" topic in XL Help. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Auto Fill
    ... Row references won't change as you drag across, ... "About cell and range references" topic in XL Help. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Change All Instances of a Cell Reference in a Formula
    ... Being able to drag all the references at once would be ... For example, when you enter a particular cell, Excel ... I was thinking maybe there would be a shortcut ...
    (microsoft.public.excel.misc)
  • Re: Adding and Multiplying Question
    ... on the bottom right of the cell with the above formula ... and drag down to row 260. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: "Insert Function" pop-up in Excel 2003, has anyone figured out
    ... Right-click the menu bar. ... double click the lower right corner to drag down the whole 4096 row ... > find the cell I want and enter it's coordinates. ... Or drag so it references ...
    (microsoft.public.excel.worksheet.functions)