Revealing formulas

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

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
 
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
 
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






.
Click to expand...
 
Back
Top