Searching
 

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

Searching
 

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

HTH
Henry

"LC" wrote in message
...
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