How to show the formula of another cell
 

Hi

I want to show the content (formula) of another cell. For instance, if the
formula in A1 is =2*12, I want cell B1 to show =2*12 instead of the answer
(24). In other words i want the answer as usual (24) in A1, and in B1 I want
the formula of A1 to be showed (=12*2).

I am not interested in showing all of the formulas in the sheet, like you
can do with tools/options/view/formulas.

Please help!

How to show the formula of another cell
 

Hi

You can use this UDF:

Public Function ShowFormula(MyCell As Range)
ShowFormula = MyCell.Formula
End Function

Copy the function into workbook module. After that, you can use it in this
workbook as any other formula. P.e. into B1 enter
=ShowFormula(A1)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Bol" wrote in message
...
Hi

I want to show the content (formula) of another cell. For instance, if the
formula in A1 is =2*12, I want cell B1 to show =2*12 instead of the answer
(24). In other words i want the answer as usual (24) in A1, and in B1 I
want
the formula of A1 to be showed (=12*2).

I am not interested in showing all of the formulas in the sheet, like you
can do with tools/options/view/formulas.

Please help!

How to show the formula of another cell
 

Thanks, that solved the problem. By the way, is it not possible to do this
without a UDF?



Hi

You can use this UDF:

Public Function ShowFormula(MyCell As Range)
ShowFormula = MyCell.Formula
End Function

Copy the function into workbook module. After that, you can use it in this
workbook as any other formula. P.e. into B1 enter
=ShowFormula(A1)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )