|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Displaying Cell Formulas (without using Tools/Options/View-For
You are welcome.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"DSMessenger" wrote in message
...
Thanks constantly amazed by the depth of Excel knowledge of people on
this
forum.
That works great but I would like to understand how it is done.
Understand the use of INDIRECT Function and assume using R1C1 Style
reference, rather than A1 Style reference, so that the Name works across
multiple Worksheets without having a Sheet Reference.
Understand the use of CELL Function (and previously tried to use it to do
this) but only knewi nfotypes address, col, color, contents,
filename, Format, parenthesis, prefix, protect, row, type,
and
"width".
So not sure whether 6 is one of these or something different altogether.
Searched the Excel Help File for GET and dont find it. Although if I
search for GET in VB Help File it finds lots of Get*** type keywords and
if
I type GET into a VB module it obviously understands it.
Any suggestions where to look so I can get more information ?
"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)
|