Hello,

I have a spreadsheet with multiple columns that I need to sort, by writing a macro, based on 2 keys.

1) Name
2) Date and Time(occupies one cell in the spreadsheet)

I have sorted based on name, but I am having difficulty sorting the date based on date and time, as Excel does not recognize the "date and time" column as pertaining to a particular format.

An example would be:

Date and Time of Events | Events
01-SEP-2007 01:46:15 AM | Event3
01-SEP-2007 12:46:08 PM | Event4
01-NOV-2006 12:19:10 PM | Event2
01-SEP-2007 01:46:18 PM | Event5
02-AUG-2004 03:46:01 PM | Event1


How do I get the data sorted chronologically?

Kindly help.

Try recording a macro where you sort the data manually, then modify that according to your needs.

I've had the same problem, if I recall, Excel doesn't store a DateTime internally as such, instead it stores it as a number. Try using a Double variable to hold the Date/Time if you're writing some sorting algorithm, though not sure why you wouldn't just use Excel's built-in sorting capabilities.