Okay, so I finally figured out how to get my array to work. It's inputting
dates that it finds in cells on another tab (looking up based on criteria and
returning all results in seperate cells).

Here is the problem. If I copy the array down only 10 rows, and I have the
filter on, it will still give me the ability to sort the output as dates
(which it should since they ARE dates). However, if I copy it down even 1
more cell, it changes the default sort to "A to Z" and will no longer let me
sort them as dates. (Instead of giving me the sort options of "Oldest to
Newest" and "Newest to Oldest" it gives me "A to Z" and "Z to A". I'm am
using Excel 2007.)

I have to be able to sort them as dates. What should I do?