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

Please post your code and someone should be able to show you what needs to be
done.
--
HTH,
Barb Reinhardt



"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

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