Find Text String in Worksheet, return Cell Referenc

Dukesford

Board Regular
Joined
May 30, 2007
Messages
106
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

stnkynts

Board Regular
Joined
Oct 7, 2010
Messages
198
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.

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

Watch MrExcel Video

Forum statistics

Threads
1,108,808
Messages
5,524,995
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top