Sorting in 2007

  • Thread starter Thread starter LuisE
  • Start date Start date
L

LuisE

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.
 
I didn't start xl2007 to test this, but I've seen this kind of stuff posted in
the newsgroups:

activesheet.Sort.SortFields.Clear
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting help !!!!!!!!!!!!!!!!! 1
Worksheet sorting code/technique advise 55
Sorting Columns with a Formula 1
Macro Button to Sort Columns - Troubleshooting ideas? 1
VBA- Excel Programming:- 0
Variable sorting 1
Determining current sort 3
Sort in Office 2007 6

Back
Top