Find the column you are in

[Rishi Dhupar]

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

 

[Norman Jones]

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

 

[Rishi Dhupar]

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