Murray Brown
asked on
Excel VBA Find row and column number of word
Hi
What Excel VBA code would use to find a partial match of a word "AC223" using the FIND function and return the row number and column number of the cell found?
What Excel VBA code would use to find a partial match of a word "AC223" using the FIND function and return the row number and column number of the cell found?
cells.find("AC223",,,xlpart).row
cells.find("AC223",,,xlpart).column
cells.find("AC223",,,xlpart).column
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks very much. That'll work well
Sub Search_Range_For_Text()
Dim cell As Range
For Each cell In ActiveSheet. usedrange
If InStr(cell.Value, "AC223") > 0 Then
debug print cell.address
End If
Next cell
End Sub