JustATheory
IS-IT--Management
Greetings,
Please review the thread I've mentioned below. I use Geoff's example with great success, but I'm looking now for something to do the opposite. For instance, look for records that do not contain "Hello". Thanks in advance for your assistance.
Thanks,
Andy
thread707-1225330
Example
With Worksheets(1).Range("A:A")
Set c = .Find("HELLO", lookin:=xlValues, lookat:=xlpart)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.offset(0,1).value = "X"
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Please review the thread I've mentioned below. I use Geoff's example with great success, but I'm looking now for something to do the opposite. For instance, look for records that do not contain "Hello". Thanks in advance for your assistance.
Thanks,
Andy
thread707-1225330
Example
With Worksheets(1).Range("A:A")
Set c = .Find("HELLO", lookin:=xlValues, lookat:=xlpart)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.offset(0,1).value = "X"
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With