pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 461
- Office Version
- 2016
- Platform
- Windows
I have a table with tens of thousands of rows, filtered via slicers. Once slicer settings are applied, I'd like all of the visible cells to be deleted, and then clear the filter so that the surviving rows are visible. I've tried code that uses a loop-through, but it takes far too long to cycle through each row individually.
Keeping in mind that this is a table (named "Worksheet") and that the rows are filtered via slicers, is there a more efficient way to clear the visible rows and then display the ones that remain?
Thank you in advance!
Keeping in mind that this is a table (named "Worksheet") and that the rows are filtered via slicers, is there a more efficient way to clear the visible rows and then display the ones that remain?
Thank you in advance!