"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 |
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 . |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com