I didn't start xl2007 to test this, but I've seen this kind of stuff posted in
the newsgroups:

activesheet.Sort.SortFields.Clear

LuisE wrote:

I need a macro for 2007 to sort by columns A, B and C then after I do
something else I need to resort by D, A, B and C.

The problem I think is that Excel keeps the original sorting criteria and
adds the new to the end. How can I reset the sorting conditions to it starts
fresh the second time?

Thanks in advance

--

Dave Peterson