Good afternoon,
I am very new to VBA and wanted to understand sorting on multiple worksheets to it's most basic form. I look at previous posts and am completely confused. I am able to sort the active worksheet, but it's not looping to any of the others.
Any help would be greatly appreciated
Thanks,
Mike
Please Login or Register to view this content.
Last edited by Michael Chandrapal; 09-27-2010 at 06:00 PM.
Break the habit now of "selecting" things in VBA. It's not needed, and in cases like yours actually makes things more difficult.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you for your reply Jerry. Works great! Do have a follow up question.
I thought adding in another level of sorting would have been easy. Unfortunately, not the case. Searched through multiple posts and nothing seems to be working. I tried adding Key 2, Order2 as shown below:
Column L and BM are both text columns. Not sure why it isn't working, would you be able to help please?Please Login or Register to view this content.
Thanks,
Mike
Turn on the macro recorder and let it record you sorting the range by the two sets of criteria and then look at the resulting code. You should be able to adjust the code I offered adding in the Key2 and Order2.
I think the problem is you don't really put a "range" in the Key values, typically, just the cell at the top of the range. Give it a try.
Hi Jerry,
Recorded the following code. I attempted to incorporate it with your VBA code and nothing seems to be working. I am trying to learn how to do this and don't think going sheet by sheet is the best way. Stumped on this one :s
Please Login or Register to view this content.
Please Login or Register to view this content.
I just noticed you're Excel 2007 is applying some sort of combination of AutoFilter and Sort, something I don't do in Excel 2003, but the code from 2003 for sorting by 2 columns is still pretty basic and works in Excel 2007.
Dynamite!!! Thanks Jerry... Works perfectly!
Delete last post.
Last edited by Michael Chandrapal; 09-28-2010 at 02:54 PM. Reason: Delete Post
I just had an application for this, sorting phone numbers, with 4 columns: LD, AC, Prefix, and Nbr.
After trying the macro recorder, and searching this and other sites, I modified the macro written by the recorder to
always adjust to the number of lines in my data. The columns are hard-coded, to sort by LD, then AC, then Prefix, and
then Nbr (columns A through D respectively), and I have the first 2 rows with header information. So, I sort on rows 2
through the last row, using Row2 2 as a header.
This may not be exactly what you are looking for, but maybe it will give you a start to be modified.
Good Luck!
Code: (My first post, so I hope I did it right. Thanks for any tips, etc.).
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks