Thread: Searching
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Henry[_4_] Henry[_4_] is offline
external usenet poster
 
Posts: 72
Default 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