title: How to find the most recent date in a date column using VBA
body: <p>I have a column of dates which are linked to other data and I am happy with how they are sorted. So without sorting the data in the excel sheet I need to find the most recent and the oldest dates in that column.</p>
  
  <p>I have had the following code so far which are not that helpful.</p>
  
  <pre><code>Max_date = Application.WorksheetFunction.Max(Columns("X")).Value
  
  MsgBox Max_date
  </code></pre>
  
  <p>Thanks
  H</p>