formula are strings. Usually I use the FIND in the worksheet menu to locate
the formula instead of writing VBA code. You can use for if necessary

mystring = Range("A1").formula
if Instr(mystring,"F34") 0 then
'enter your code here
end if



"Michael Kintner" wrote:

I am trying to compare some old spreadsheets and upgrade to the new and have
a case in try to determine if a value was added to a formula inside a cell.
So I would like to do a search/find on the contents of the FORMULA in the
cell.

Example: Cell A1 Contains a formula +F12+F34+F67

Is there a function that can search the formula? Example: FIND "F34" in
cell A1. Everything I can see so far you can only search the results, not
the formula.

Thank you in advance for your help!!!
Mike