Hey everyone, I'm a little new to VBA and I got a quick question.
I'm sorting columns a-c from row 1-26 based on column a, from a-z. I'm trying to repeat this for columns d-f, g-i, j-l, etc..
Here's my code so far, there's a problem with it though and I was hoping someone could help me out.
Please Login or Register to view this content.
Last edited by JBeaucaire; 10-19-2014 at 02:54 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Hi,
What exactly is the problem you encounter? Are you getting a VBA error message or just not getting the results you expect?
But perhaps a more fundamental question, what's the point of sorting different columns as the loop processes. Why not just sort on the 12th column?
Your error though is no doubt associated with code like
What is this trying to do?Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
so i'm trying to select a1:c26 and sort it by column a. then i want to to jump 3 columns over and select d1:f26 and sort by column d. so on and so forth.
Untitled.jpg
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Wow that's awesome thanks, works perfectly.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks