View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default 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