You didn't say that at the outset.

If you wish to copy *across* columns, along a row, try this in C3:

=INDEX(Rates!$D:$D,COLUMN(C:C))

And as you drag across Row3, you'll get D4, D5, D6 ... etc.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
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)
>
>