Thank you! That worked like a charm!

"Myrna Larson" wrote:

I assume your column contains one of the codes you list. You can set up a
custom sort order. Check it out in Help. Then you have to use Data/Sort and
specify the custom order for this column (which must also be the 1st key).

On Thu, 16 Sep 2004 19:53:05 -0700, kristenlc
wrote:

I have some data I am pulling from a system that records days of the week as
M, T, W, H, F, S, and U (Monday, Tuesday . . . . Sunday). I need to sort the
list so that it is in the order that the week follows (above) as opposed to
alphabetical (the result I get when I use the sort feature). I'm pretty
comfortable with everything in Excel except for VB which I fear holds my
solution. Does anyone out there have an idea??