Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

You could copy the formula from the Formula Bar so that the references don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

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

"SDMFG" wrote in message
...
Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

I would like a function that would do this automatically, though.

"RagDyeR" wrote:

You could copy the formula from the Formula Bar so that the references don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

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

"SDMFG" wrote in message
...
Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

You would need VBA then or Excel4 macro


For VBA


http://www.mvps.org/dmcritchie/excel/formula.htm


http://www.mvps.org/dmcritchie/excel...ll.htm#install



Or you could do insertnamedefine and assume that the formula is in A6

then use

=GET.CELL(6,Sheet1!$A$6)

in the refers to (replace Sheet1 with your sheet name)


You could call it GetFormula


then use

=GetFormula



--


Regards,


Peo Sjoblom

"SDMFG" wrote in message
...
I would like a function that would do this automatically, though.

"RagDyeR" wrote:

You could copy the formula from the Formula Bar so that the references
don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

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

"SDMFG" wrote in message
...
Is there a function that will display the formula in a cell? For
example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

The VBA site helped, thank you.

"Peo Sjoblom" wrote:

You would need VBA then or Excel4 macro


For VBA


http://www.mvps.org/dmcritchie/excel/formula.htm


http://www.mvps.org/dmcritchie/excel...ll.htm#install



Or you could do insertnamedefine and assume that the formula is in A6

then use

=GET.CELL(6,Sheet1!$A$6)

in the refers to (replace Sheet1 with your sheet name)


You could call it GetFormula


then use

=GetFormula



--


Regards,


Peo Sjoblom

"SDMFG" wrote in message
...
I would like a function that would do this automatically, though.

"RagDyeR" wrote:

You could copy the formula from the Formula Bar so that the references
don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

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

"SDMFG" wrote in message
...
Is there a function that will display the formula in a cell? For
example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!