Thread: "real" formula
View Single Post
  #2   Report Post  
 
Posts: n/a
Default

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
.