Thanks. The sort method seems to work, but I think that I need to change the date format in TempW(i, 1) since my array sorts to
TempW(1,1) = 1/31/2004
TempW(2,1) = 1/31/2005
TempW(3,1) = 1/31/2006
TempW(4,1) = 1/31/2007
TempW(5,1) = 10/31/2004
..
..
TempW(9, 1)= 11/30/2004

etc etc

I tried to convert the dates in the array to the general format, but I keep returning a 'False' or '12:00:00 am' when I do. e.g.

TempW(q, 1) = FormatDateTime(TempW(q, 1)) = "General Date"

What do I need to do to get around this?

Thank you