FInding Match in more than 1 cell

[ManUBlueJay]

I need to find a given text in a cell in "myRange" and change the value 2 cells over. The first one is easy using Offset and match. Does any one have any Idea how to find the others. A little VBA script would also be fine as I would run it from a macro anyway.

 

[Peter_SSs]

It isn't clear whether "myRange" is a named range or a vba variable. I have assumed the latter.
You could try something like this

Dim rFound As Range
Dim firstAddress As String

Set rFound = myRange.Find(What:="abc", LookIn:=xlValues, LookAt:=xlWhole)
If Not rFound Is Nothing Then
  firstAddress = rFound.Address
  Do
    rFound.Offset(, 2).Value = "new value" 'or whatever you want to with that cell 2 over
    Set rFound = myRange.FindNext(After:=rFound)
  Loop While rFound.Address <> firstAddress
End If

If "myRange" is actually a named range then change each myRange in the above code to Range("myRange")

 

[ManUBlueJay]

Thank You. Unfortunately "MY Range is a Named Range. Could you help me with that?
Thanks

 

[Peter_SSs]

Thank You. Unfortunately "MY Range is a Named Range. Could you help me with that?
Thanks

I thought I already did. Did you read the text in my last post under the code box?