Hello All,
I would like to create a MACRO that detects all hidden rows and stores the row numbers in a global variable. After this, a person will filter the sheet. After the filter, I would like to create another MACRO which re-hides all the previously hidden rows. I am having a problem even getting started with this MACRO. Any help is appreciated.
If you guys have any questions about the MACRO, please ask in the comment section.
Thank you a ton,
Andrej Sulek
Last edited by Andrej Sulek; 06-18-2019 at 01:17 PM.
Are you talking really talking about HIDING / unhiding rows, or are you trying to restore a previous FILTER?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I am talking about hiding and unhiding the rows. The filter automatically unhides the rows that the filter condition applies to. I am looking to hide all the rows that were hidden before the filter.
Something like:
Please Login or Register to view this content.
Perhaps using a range would work as well?
Changing columns(1) to a reduced range (say A1:A & last row) would be a huge performance improvement, but wasn't sure of your requirements.Please Login or Register to view this content.
Last edited by Arkadi; 06-18-2019 at 11:09 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
That worked perfectly. Thank you <3
Glad we could help Andrej
Please remember to mark the thread as solved when you have a chance?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks