title: Excel Macro: Selecting a specific Row based on column date
body: <p>I am writing my first macro and have a question on how I can select a specific Row based on a value in a specific column. here is my code so far:</p>
  
  <pre><code>Sub Pipeline()
  
  'Module 3
  'Iterating through the Funding Date Column and looking for clients going live within 30 days
  'Selecting the rows for each client in that target range
  'TODO: Export information into an email template in Outlook
  'TODO: Send email to distribution list
  
  
  Dim fundingDate As range
  Set fundingDate = range("M4:M500")
  
  Dim todaysDate As Date
  todaysDate = Date
  
  For Each cell In fundingDate
    If cell &lt; todaysDate + 30 Then
     'Need to select the entire row
    Else
    cell.Font.ColorIndex = 3
  End If
  Next
  
  End Sub
  </code></pre>