LinkBack URL
About LinkBacks
I want to sort headers ascending if they are sorted descending and descending if they are sorted ascending.
At the moment I have the following code:
How can I do this?
Please Login or Register to view this content.
I want to sort headers ascending if they are sorted descending and descending if they are sorted ascending.
At the moment I have the following code:
How can I do this?Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for your quick reply! Unfortunately the code doesn't allow me to click one time to sort ascending and then click one time again and sort descending.
Where do you want to clic, in the header ?to click one time to sort ascending and then click one time again and sort descending.
- Battle without fear gives no glory - Just try
Hi, thank you for your reply! You are correct, click the header one time and it sorts descending/ascending. Click again and it sortes vice versa!
How aboutPlease Login or Register to view this content.
Thank you Fluff13, your code works flawlessly!
Would it be possible to have 3 instances of the code running? For 3 different tables I am filtering.
What are the ranges for each table?
Table1 has range B10:O300
Table2 has range B303:O593
Table3 has range B596:O886
How aboutPlease Login or Register to view this content.
Flawless! Thank you!
After I filter the 3 tables, ActiveSheet.ShowAllData only resets one table. Perhaps you know how to fix it?
Glad to help & thanks for the feedback
You'll need to loop through the tables, if you have problems with that, then you'll need to start a new thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks