Searching

[LC]

Hi,

I am very confused why this code doesn't work. In the
watch window the text value is the same as the
line1.offset value but the if statements is never excuted.

For Each line1 In Category.Cells
If (line1.Offset(0, 1).Value = text) Then
TotalExist = True
Exit For
End If
Next line1

Thank you in advance,
LC

 

[Henry]

LC
Unless text is a variable name
If (line1.Offset(0, 1).Value = "text") Then
should work.

HTH
Henry