Hello,
I have the below codeWhich simply sorts items using the sheet name. I'd like to go further and have the macro delete every item that DOES NOT show in the filter. Namely, everything else.Please Login or Register to view this content.
Hello,
I have the below codeWhich simply sorts items using the sheet name. I'd like to go further and have the macro delete every item that DOES NOT show in the filter. Namely, everything else.Please Login or Register to view this content.
Did you consider to change criteria to <>ActiveSheet.Name and then delete entire rows for visible cells?
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
HTML Code:
Thank worked
Thanks!
This seems more logical to me if a table is used anyway.
Please Login or Register to view this content.
Messages have been translated from Dutch to English by means of google translate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks