View Single Post
  #10 (permalink)  
Old October 25th, 2004, 06:20 AM
gcianfanelli gcianfanelli is offline
Authorized User
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

InStr returns an integer, indicating where in the string a match was found.

Therefore:

Code:
  If InStr(1, UCase$(myCell.Value), "RECOVERY", vbTextCompare) = 0 Then
    '...
  End If


is the construct you need. A return value of zero means the string "RECOVERY" was not found in myCell.Value
Reply With Quote