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.

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

For more clarification on my question:

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.

"StaceyJ" wrote:

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.

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