title: Find cell based on Date in Excel VBA
body: <p>I have a file with a few columns including one with dates and another with some integers. </p>
  
  <p>I want to obtain the row number of a cell based on its date. So in column B, I want the row number of the cell containing the date 31st of December 2018. The display format in the workbook is "31-Dec-2018" and when clicking on the cell it shows 12/31/2018. I tried using</p>
  
  <pre><code>ActiveSheet.Range("B3:B500").Find(What:=CDate("Dec. 31, 2018")).Activate
  </code></pre>
  
  <p>and</p>
  
  <pre><code>ActiveSheet.Range("B3:B500").Find(What:=12/31/2016).Activate
  </code></pre>
  
  <p>But neither works as I get an error "Object Variable not set"). I have been googling a lot and couldn't find a suitable solution which activates the relevant cell. What's wrong with my approach?  </p>