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



---
Regards,
Norman



"Rishi Dhupar" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Rishi Dhupar]

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