This is a method will find a cell with some text and then return cell reference. 

With spreadsheet
    Set findCell = .Range("A:A").Find(What:=findMe, LookIn:=xlValues)
End With
refRow = findCell.Row
refColumn = findCell.Column

Categorized in:

VBA Excel,

Last Update: May 18, 2024