title: Find row containing specific value
body: <p>I have an Excel worksheet where every cell in column A is a date in sequential order. </p>
  
  <pre><code>    A    
  ----------
  1/01/2016
  ...
  12/31/2019
  </code></pre>
  
  <p>How can I return the row number of where a specific date is found?</p>
  
  <p>Something like this:</p>
  
  <pre><code>Private Sub btnSubmit_Click()
  
      today = Date
  
      row_today = ThisWorkbook.Sheets("Sheet1").Range("A:A").Find(What:=today, _
          LookIn:=x1Values)
  
      MsgBox row_today
  
  End Sub
  </code></pre>