The ws is a list of ralle ticket books, who signed them out, when they were
returned and how many were sold. I want to SORT on the column "when they were
returned" or COLUMN E in my sheet. I selected the entire PRINT AREA which is
cells 1 thru 1002 and columns A thru M (this includes the headers) . Key 1 is
COL E or Date Returned" in MM/DD/YY format.

"Fred Smith" wrote:

This operation should be pretty straight forward. Excel should handle it easily.
What do you have highlighted before you click on DataSort...? What do you enter
for Key1, 2 and 3?

--
Regards,
Fred


"75gator" wrote in message
...
I want to SORT a worksheet by a column that is formatted as a date. I keep
getting the following message whenver i try, "This operation requires the
merged cells to be identically sized".

So i copied all the cells into a new worksheet that had all cells in default
sixe format. Result was the same.

What am I doing wrong?