I have code that is doing a filter. it works great. I would now like to sort the first column in ascending order. I have tried the following but it does not work. The code in red is the part that is not working.
Please Login or Register to view this content.
It should bePlease Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
It does not work. "A2" is being filtered out by the code before the sort.
So you want to first apply the filters and then sort the data?
Yes, exactly.
That can mess up your data. Why not filter the data and copy to another sheet? Then you can sort the data in the new sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks