Develop Procedure to Load Lookin: Values rather than Formula

[DougStroud]

I would like some help in writing a Sub to change the default value in the Find Replace dialog box to Values, rather than Formulas.

Anyone interested?

Thanks,

Doug

 

[venkat1926]

an EXAMPLE code (to be modified for you)
Cells.Find(what:=11, LookIn:=xlValues, after:=Range("a1")).Activate