Take a look at what Like does in VBA's help:

then try this:

Option Explicit

Sub testme01()
Dim cellA As Range
Dim cellB As Range

With Worksheets("sheet1")
Set cellA = .Range("a1")
Set cellB = .Range("b1")

cellA.Value = "*hi*"
cellB.Value = "hi"

MsgBox (cellB.Value = cellA.Value) & vbLf & _
(cellB.Value Like cellA.Value)

End With
End Sub



"H. Zhu" wrote:

What difference do the following two statements make

if cellA like cellB then

if cellA = cellB then

Thanks in advance

--

Dave Peterson