title: Excel 2007 VBA Find row based on date
body: <pre><code>Date | data | data | data
  12/29|   G  |   F  |  G
  12/30|   G  |      |
  </code></pre>
  <p>I have a spreadsheet like above.  I want to find the row that is the current date, then reference the row that is the current date in a Range type.  Then cycle through the data in that row.</p>
  <p>I can find the current date, and get the address of the cell that is the current date:</p>
  <pre><code>dateRange = &quot;A1:&quot; &amp; regionSheet.Range(&quot;A1&quot;).End(xlDown).Address
  
      For Each cell In regionSheet.Range(dateRange)
        If cell.Value = Date Then
        row = cell.Address
        End If
      Next cell
  </code></pre>
  <p>That returns $A$2. I need to somehow turn this into a <code>Range</code> type. I tried using the cell.Address like below:</p>
  <p><code>row = cell.Address &amp; &quot;:&quot; &amp; regionSheet.Range(row).End(xlRight).Address</code></p>
  <p>but that errors out.</p>
  <p>Maybe I'm going about this the wrong way? Any ideas?</p>