Macro not sorting correctly

Question

In Excel 2010 I created a macro for a csv file, and sorted by a date/time field. It seems to sort fine until the bottom where it adds in earlier entries that are out of chronological order. Upon the first run of the macro the sorting is correct, upon each subsequent run more out of order date/times get added to the bottom. Does anyone know what might be causing this?

Answer 1

I think I figured it out, when I recorded the macro there were less rows than subsequent runs (as each run of the csv has more data than the last). Once I increased my rows in the code upon subsequent creations as row count increases they are being captured in the sort.