Atem,
AFAIK, there is no way - possibly using some Excel 4 XLM code, but that is often a dicey
proposition.
HTH,
Bernie
MS Excel MVP
"Lacty" wrote in message
...
Bernie
Thanks for the response. But isn't it possible within Excel other than
using a user defined function?
Kind regards
Atem
On Mar 6, 2:12 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Lacty,
Function MyForm(myC As Range) As String
MyForm = myC.Formula
End Function
Copy that code into a regular codemodule, then use it like
=MyForm(A3)
HTH,
Bernie
MS Excel MVP
"Lacty" wrote in message
...
Hi
Does anyone know how to write a formula which will return the formula
in another cell as a string?
e.g if A3 contains the formula A1+ A2, I want to write a formula in B3
with will return the formula in A3 as string '= A1 + A2. Hence the
value in B3 will be string '= A1 + A2
Thanks in advance
Lacty