title: Excel VBA: Unable to Filldown from Date Variable in VBA
body: <p>My goal is to find the most recent date in <code>column A</code> (the date in <code>column A</code> is determined by a formula) and filldown one row from the most recent date in <code>column A</code> through <code>column T</code>.</p>
  
  <p>I am able to locate the most recent date in <code>column A</code> utilizing </p>
  
  <pre><code>Max_date = Application.WorksheetFunction.Max(Columns("A"))
  </code></pre>
  
  <p>but when I try to identify it in a range I am unsuccessful.</p>
  
  <p>Below is the total of failing code:</p>
  
  <pre><code>Sub Find_Date()
  
  Dim Max_date As Date
  
  Max_date = Application.WorksheetFunction.Max(Columns("A"))
  
  Worksheets("Sheet1").Range("A" &amp; Max_date).End(xlDown).FillDown
  
  End Sub
  </code></pre>