LinkBack URL
About LinkBacks
I can't beleive I can't make this work...
All I am trying to do is sort a section of data on another tab in my spreadsheet and it does not work. Here is the code:
Please tell me what I am doing wrong.
Please Login or Register to view this content.
I can't beleive I can't make this work...
All I am trying to do is sort a section of data on another tab in my spreadsheet and it does not work. Here is the code:
Please tell me what I am doing wrong.Please Login or Register to view this content.
Hi
You need a range of cells to sort for the sort key
Key1:=Sheet9.Range(AV61") should be a range of cells like Key1:=Sheet9.Range("AV61:AV67") something like that
It still returns an error I'm afraid:
Please Login or Register to view this content.
Why don't you just record a macro.
Start the macro recorder, and select the range and sort it as you want then stop the recording, look at the vba code and see what's wrong if you cross-check it with your macro
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I did mate. That's how I got the original macro. I don't know why it does not work when I use it in another macro.
I did have to change it from using the active sheet to referencing another sheet without selecting though. I guess that is what broke it.
I also changed the sheet names to sheet codes...
Hi mate,
I used your macro, no changes except for the columns and it works with extra editing even if I call it from another sheet and from a macro
Please Login or Register to view this content.
I've learnt something out of this too. I didn't think of trying to do a sort with one cell as the key
This is how i would do it
Good luckPlease Login or Register to view this content.
Hello rsmithline,
The code you have would work with Windows prior to 2007 just fine. In 2007, sorting was expanded to apply to more objects.
The old sort method only allowed for 3 levels of sorting. Now, it can handle as many levels as memory will allow. This is accomplished through the SortFields object.
Each worksheet has its own Sort object. Anytime you do a sort, any SortFields that have been set previously will remain in effect. You should always clear the SortFields before add the fields you want to use.
Here is an example using your code. The sort assumes there are headers in cells "AV61, AW61, AX61, and AZ61".
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
True, and you can add extra sorting conditions
Please Login or Register to view this content.
Fixed now! Thanks guys!
Hello rsmithline,
You're welcome. Hopefully, the new sorting method makes more sense now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks