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?