how to find a STRING in a worksheet and select the cell containing it.

[excelkeechak]

I want to know how to find certain String and select the cell it on finding the String.

[Andy Pope]

Have a look at the FIND function

[excelkeechak]

Its ok. but i want vba code for looping it Through the sheet.Find the string. copy it and paste it.

[Andy Pope]

This is direct from the help on Find in VBA

With Worksheets(1).Range("a1:a500")
    Set c = .Find(2, lookin:=xlValues)
    If Not c Is Nothing Then
        firstAddress = c.Address
        Do
            c.Value = 5
            Set c = .FindNext(c)
        Loop While Not c Is Nothing And c.Address <> firstAddress
    End If
End With

[excelkeechak]

HUH, i had seen the code in the excel help file but i m unable to understand it properly i want clear cut code

[Andy Pope]

What bit don't you understand?

If you want more detail then perhaps you can provide us with more detail.