Have the following code
Range("A1").Select
Set SearchRangeA = Columns("A:A")
Dim HeadCoach As String
HeadCoach = SearchRangeA.Find(what:="Staff Member").Offset(2, 0).Select
ActiveCell.Offset(4, 0).Select
What I wish to happen is to search column A to find the cell with the string "staff...