If Activecell.Value = "ABC" Then...
but if you really mean CONTAINS, as opposed to EQUALS:
If Instr(Activecell.Value,"ABC")0 Then...

FOr 2nd part, replace "ActiveCell" with something like Range("E6"):

If Range("E6").Value = "ABC" Then...

Bob Umlas
Excel MVP

"?????" wrote in message
...
what is the macro to identify if the activecell contains value
and what is the macro to identify if cell XX contains value

thank you
rozent