Searching cells for hard coded data vs formulas

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

Can anyone tell me how to define a Find query in cell which will fin
all the cells in a sheet which have constants in them (i.e. =2, 2, A2+
etc). That is, I want to build an audit function which checks cells t
make sure there are not any hard coded constants in any cells. Th
goal will be to automate it at a later date. For now I just want t
know what the syntax is for the query in the Find option.

Thank-yo
 
Hi

Try menu Edit > Goto > Special and check Constants (or Formulas) and the
preferred subtypes text, numbers, logical, ...
Record a macro while doing this for VBA syntax.

HTH. best wishes Harald
 
Back
Top