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