Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revealing format of a cell | Excel Discussion (Misc queries) | |||
Revealing the related pivot data | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
revealing the contents of a formula | Excel Worksheet Functions | |||
Again-revealing the contents of formula | Excel Worksheet Functions |