Posted to microsoft.public.excel.programming
|
|
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
.
|