Find the column you are in
 

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

Find the column you are in
 

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

Find the column you are in
 

I like it, thanks didn't know that existed.