I have a column (A) that contains a formula and displays the value

I would like to put in Column B a link to that formula, BUT there the formula should be displayed, and not the value.

Any ideas? Using "show formula" in Tools -> Options is not helpful, as I do not want to to display the formula in column A.

p.s. i use Excel 2003



Thanks

Hi,
Try this function:

Function CellFormula(CellRef As Range) As String
CellFormula = CellRef.Formula
End Function

You implement it by first pressing Alt-F11.
Then select the menu Insert/Module.
Now paste the code above.
Alt-Q to go back to Excel.

I am a macro beginner, but it looks like it works when I tried it

In cell B1 (for example) you can now type: =CellFormula(A1) to show the formula that is written in cell A1. This formula can of course by copied down or where ever you like.

Kind regards
Bjorn

Thanks Bjorn,

it seems to work fine. However, I found a simpler way that suits my needs.

I added an extra column to the right of my formula, and did a Copy-Paste special (formula). I then added a quote sign ( ' ) in front of the formula and dragged the formula down. this will turn the cell into a "text" field, thus displaying the formula.