No, no good enough.
What happens if I do not drag down to C4 but drag right to D3.. ?
I will still not get =Rates!D5

rgds


"RagDyer" wrote:

> If you select C3 and click on the "fill handle" (little black square in
> lower right corner of cell), and drag down to the next (C4) cell, you'll get
> the
> =Rates!D4
> to change to
> =Rates!D5
>
> Is that not good enough?
>
> =Rates!D(4+1)
> *Doesn't* accomplish anything in XL!
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > Is there a function that returns the formula in a cell?
> > Example:
> > Cell C3 contains the formula =Rates!D4
> > I need a formula that returns this in such a format that I can convert the
> > contents to =Rates!D5 or infact to =Rates!D(4+1)
>
>