You might "like" this. It will pick up abc wherever in the cell.

Sub likeabc()
If UCase(ActiveCell) Like "*ABC*" Then MsgBox "HI"
End Sub

--
Don Guillett
SalesAid Software

"kevin" wrote in message
...
Hi i have some code where one line is if a cells value = "ABC" then do
something. sometimes however it may be ABC inc or ABC corp. The help
function wasn't clear on how to search for ABC*. what is the correct syntax
pls.

Thks