Revealing formulas
 

Hello,
In Excel, if the user presses ctrl+` (the backwards
apostrophe) the sheet display values become the forumlas.
This is helpful for auditing. I need to show those actual
values in another part of the sheet -- for auditing
purposes. is there a function, or a way that I can
capture the text of a formula so I can display it elswhere?

thanks

keith

Revealing formulas
 

Keith,

You can use a VBA function like the following:

Function GetFormula(Rng As Range) As String
GetFormula = Rng(1, 1).Formula
End Function

You can then call this function from a worksheet cell. E.g.,
=GetFormula(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Keith" wrote in message
...
Hello,
In Excel, if the user presses ctrl+` (the backwards
apostrophe) the sheet display values become the forumlas.
This is helpful for auditing. I need to show those actual
values in another part of the sheet -- for auditing
purposes. is there a function, or a way that I can
capture the text of a formula so I can display it elswhere?

thanks

keith

Revealing formulas
 

Hi Chip,
Thanks very very much,
Keith
-----Original Message-----
Keith,

You can use a VBA function like the following:

Function GetFormula(Rng As Range) As String
GetFormula = Rng(1, 1).Formula
End Function

You can then call this function from a worksheet cell.
E.g.,
=GetFormula(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Keith" wrote in
message
...
Hello,
In Excel, if the user presses ctrl+` (the backwards
apostrophe) the sheet display values become the
forumlas.
This is helpful for auditing. I need to show those
actual
values in another part of the sheet -- for auditing
purposes. is there a function, or a way that I can
capture the text of a formula so I can display it
elswhere?

thanks

keith


.