Thank you.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"DSMessenger" wrote in message
...
Also I visited your Website Ashish, and added it to my list of Excel
Sites,
and will take the time to read through some of your other examples. I am
in
Australia so a long way away from India. Thanks again.

"Ashish Mathur" wrote:

Hi,

you can try this. Go to insert Name Define and assign a name there -
"showformula". In the refers to box, type
=GET.CELL(6,INDIRECT("RC[-1]",)).
In cell B1, enter =showformula.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"DSMessenger" wrote in message
...
Is there any way to display the Formula of another individual cell (not
all
cells on the Worksheet as per using Tools / Options / View then
selecting
Formulas Check box) using Standard Excel functions (not macros).

ie if Cell A1 has formula =A2+1 want to create a method of displaying
the
formula (as text) in another Cell

Trying to avoid Macros but could do this easily by creating a VB
Function
like

Public Function TextFormula(rngFormula As Range) As String

TextFormula = rngFormula.Formula

End Function

Then having in the other Cell =TextFormula(A1)