Multiple cells
 

I would like to perform a search on each row in a single column of
names. If the name matches a specified name, I would like to insert
text into the the cell to the right of the cell with the matching name.
How do I do this? Do I use the Count property?

Multiple cells
 

Hi Nikita,

Try this, adjust dd and My text and data range.

Sub XXX()
Dim data As Range
Dim cell As Range
Set data = Range("f1:f10")
For Each cell In data
If cell.Value = "dd" Then
cell.Offset(0, 1).Value = "My text"
End If
Next
End Sub

HTH
Regards,
Howard

"nikita" wrote in message
ups.com...
I would like to perform a search on each row in a single column of
names. If the name matches a specified name, I would like to insert
text into the the cell to the right of the cell with the matching name.
How do I do this? Do I use the Count property?