Hi Rishi,

Dim Rng As Range, Rng2 As Range

Set Rng = Range(....).Find(......................)

If Not Rng Is Nothing Then
Set Rng2 = Rng.EntireRow.Cells(1)
End If



---
Regards,
Norman



"Rishi Dhupar" wrote in message
oups.com...
Probably a simple answer to this, but I am doing a find using the
Range.Find function.

It is looking in all cells. Goal is to get column A's value for the
row that my string was found. How can I do this?

Was thinking about using offset, but I cannot figure out how to get the
column the string was found on.

Thanks