Function to display formula in specified cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert E. Leonard Sr - 09 Nov 2007 20:50 GMT

I am trying to display in a spreadsheet, the formula in an adjent cell. Any
suggestions?

EXAMPLE:

cell A2 contain formula: =Mid(c3,5.2)

In cell B2 i would like to insert a formula displaying above formula.

I know that I can copy the formula to cell B2 and save as text by inserting
a space before = sign. What I am looking for is an automatic fix.

Thanks, for your help
Bob Leonard
rleonard@mich.com

Reply to this Message

RagDyer - 09 Nov 2007 21:02 GMT

This old post describes how to create a formula to do what you're looking
for:

http://tinyurl.com/y5tckh

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>I am trying to display in a spreadsheet, the formula in an adjent cell.
>Any suggestions?
[quoted text clipped - 12 lines]
> Bob Leonard
> rleonard@mich.com

Reply to this Message

Bernard Liengme - 09 Nov 2007 21:08 GMT

Here is the UDF I use for documention
Function ShowFormula(MyCell)
ShowFormula = MyCell.Address & " " & MyCell.Formula
End Function
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I am trying to display in a spreadsheet, the formula in an adjent cell.
>Any suggestions?
[quoted text clipped - 12 lines]
> Bob Leonard
> rleonard@mich.com

Reply to this Message