Thread: 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.

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.