Sorting of Date!! 1

[kuldeps]

Hello All,

Just wondering if you can help me in writing VBA sorting logic for Date in asc or dsc order.

Want to sort dates which are not in simple date format (DD/MMM/YYY).

Want to sort dates from Array1 below resulting Results_Array1

Array1 Result_Array1

100 Year 1 Day
1 Day 2 Day
Mar 2010 1 Month
2 Day 3 Month
1 Month Mar 2010
10 Year Jun 2010
3 Moth 10 Year
Jun 2010 100 Year


Thanks for your help in advance.

 

[kuldeps]

Hi JTBorton,

Thanks a lot for your help and spending time for converting code in to VBA , much appreciated.


Regards,