title: How to find a date time value in an excel sheet
body: <p>I need to find the first cell which contains a datetime value.</p>
  
  <p>The cell I am interested in displays this</p>
  
  <blockquote>
    <p>06-Mrz-2015 00:00</p>
  </blockquote>
  
  <p>It's formula field has this (two spaces after the date part)</p>
  
  <pre><code>06.03.2015  00:00:00
  </code></pre>
  
  <p>The cell format is this</p>
  
  <pre><code>DD-MMM-YYYY hh:mm
  </code></pre>
  
  <p>I tried this but it does not find the cell</p>
  
  <pre><code>Public Function FindCurrentCell() As Range
  
  Dim cell As Range
  Dim current As String
  
  Sheets("Futures").Select
  
  current = Format(Date, "dd.mm.yyyy") + "  00:00:00"
  
  Set cell = Cells.Find(What:=current, After:=Range("A1"), LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
  
  Dim test As String
  test = cell.Address
  
  Set FindCurrentCell = cell
  
  End Function
  </code></pre>