function CELL() to return the formula in the referenced cell

[Guest]

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)

 

[RagDyer]

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!
==============================================

 

[Guest]

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]

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!
=====================================================


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