Formulas containing hard coded values
Hi all,
I am in receipt of a workbook in which someone has "amended" random formulas
with harcoded additions - eg
=a1*b1*1.7
or
=if(a1=0,"None,"OK")
Does anyone have a vba approach to identify a cell that contains hardcoded
numbers or text?
Thanks in advance!
Bony
|