title: How to find a specific cell and make it the ActiveCell
body: <p>I am writing a VBA code that will open a specific worksheet in my workbook in Excel, and then find the cell in Column A that has the value "TOTAL". This then must be set as the ActiveCell, so that the rest of my macro can perform actions on the row containing this cell.</p>
  
  <p>I want it so that when the user runs the macro, this cell is specifically chosen right off the bat. The position of this cell will change after the macro is run, so I need it to work no matter what cell this value is in. Everytime the macro runs, a new row is added above the row containing "TOTAL" and therefore the position of this cell is ever-changing.</p>
  
  <p>So far I have come up with this, just from readin through forums. It still doesn't work, but I'm new to this language and I can't determine where the error is.</p>
  
  <pre><code>Sub Macro2()
  
      Dim C As Range
      Worksheets("Project Total").Select
      With Selection
          C = .Find("TOTAL", After:=Range("A2"), MatchCase:=True)
      End With
  
  End Sub
  </code></pre>