Find Text String in Worksheet, return Cell Referenc

[Dukesford]

In Cell D11 I have the word "Inlet", however when I run my report it is not always in D11, but that where the word "inlet" appears is the starting point of the data I need. So I need to find where the word Inlet appears on my reports, any ideas with an equation? To be clear, sometimes the word will load in D20, C123, E239432423.

 

[stnkynts]

Since you didn't say what you want to do with it after you find it here is how to find. You could use a Do/Loop with FindNext to get multiple instances if neccessary.

Sub FindInlet()
Dim iFind As Range
Set iFind = ActiveSheet.UsedRange.Find(What:="Inlet", LookIn:=xlValues, LookAt:=xlPart)
MsgBox iFind.Address
End Sub