How to find the most recent date in a date column using VBA
<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>