Macro to select one cell based on a value of another cell

I need a macro that will find the cell that has a text value of "Summary Results", and then select the cell in column A, two rows below.  

So if "Summary Results" existed in C10, then cell A12 should be select.  I know the offset function holds part of the key to this.

Thanks!  
KP_SoCalAsked:
Who is Participating?
 
StephenJRCommented:
I doubt you need to select, but anyway ...
Sub x()
  
Dim rFind As Range
 
With Sheet1
    Set rFind = .Cells.Find(What:="Summary Results", LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)
    If Not rFind Is Nothing Then
        .Cells(rFind.Row + 2, "A").Select
    End If
End With
     
End Sub

Open in new window

0
 
KP_SoCalAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.