Return R1C1 Address of a cell that contains specific text in Excel VBA

Hello All

I need to find a way in VBA that will find the first cell on a sheet that contains text (say "By Focus") for example, and return the R1C1 address for that cell. I then need to assign a variable the value of that R1C1 address.

I have scoured the interwebs looking for this answer and have not been able to find one.

Any Thoughts?

That returns $M$3, I would need this to return R3C13.

Any idea how to return the RC values rather than the Column Letter addressing?

I don't want to use the $M$3, I want the relative address R3C13 to be assigned to a variable then, use that in a IF THEN Statement

For example:

Dim Adr as String

Set Adr = ( THIS IS WHERE I NEED TO FIND OUT HOW TO PULL THE R1C1 ADDRESS FOR THE CELL THAT CONTAINS "BY FOCUS")

If Adr = R3C13 Then

CODE TO BE RUN