Hi crmpicco,
Yes, your syntax is wrong, try this
Note that while 'like' can be used as shown above for an exact match, the 'like' atatement is usually used with a wild-card character to find similar words E.G. "*Page" will give "Front Page", "Last Page",...etc. OR, "Page*" will give "Page one", Page two", etc.Sub LikeItOrNot() Dim sRange sRange = "A1" If Not Trim(Range(sRange).Text) Like "Page" Then MsgBox "Not Page" Else MsgBox "Page" End If End Sub
HTH,
John