Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"real" formula
I have a large spreadsheet model to audit. There is a lot of
"semiformulas" meaning formula like =4569 + (7891*0,15) and so on. I need to find a macro picking up these type of formula. I am not interested in "real" formulas created by user by means of FurmulaWizzard ( formulas concerning function names like SUM, VLOOKUP etc.) Thank you for your assistance. Jiri Cihar |
#2
|
|||
|
|||
hi,
you the keyboard shortcut ctrl+ ~ this will show formulas as formulas instead of calculations. press ctrl+~ again returns the view back to calculations. if =4569 + (7891*0.15) is calculating a value then it is a real formula. -----Original Message----- I have a large spreadsheet model to audit. There is a lot of "semiformulas" meaning formula like =4569 + (7891*0,15) and so on. I need to find a macro picking up these type of formula. I am not interested in "real" formulas created by user by means of FurmulaWizzard ( formulas concerning function names like SUM, VLOOKUP etc.) Thank you for your assistance. Jiri Cihar . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |