08-04-2005, 05:05 PM
|
|
|
|
Re: Help with INDIRECT()
I'm not sure what you're asking for. It sounds like:
A) you're using INDIRECT so that the references don't change dynamically
and
B) you want the references to change dynamically.
It's hard to see how you could have both.
In article <Sophat.1t94mp_1123178726.5478@excelforum-nospam.com>,
Sophat <Sophat.1t94mp_1123178726.5478@excelforum-nospam.com> wrote:
> 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. 
|
Linear Mode
