Hello,
I have a large table with several slicers that filter the document based on entries in different columns. I am looking for a VBA to delete all rows hidden by slicers.
I can get the job done with a script that deletes hidden rows one by one starting from the bottom up but it is very slow.
Also, I need to do that based on all hidden rows, the slicers can vary depending on the contents of the document. For example Slicer 1 may include A, B, C in one document but may include E, F, G in a different data set.
Therefore I need to write this without needing to specify the exact name of filters A, B, C, D etc; just specify to delete those rows in bulk, no matter based on what filter.
Your help would be much appreciated.
Also asked here VBA to delete rows hidden by filters
I have a large table with several slicers that filter the document based on entries in different columns. I am looking for a VBA to delete all rows hidden by slicers.
I can get the job done with a script that deletes hidden rows one by one starting from the bottom up but it is very slow.
Also, I need to do that based on all hidden rows, the slicers can vary depending on the contents of the document. For example Slicer 1 may include A, B, C in one document but may include E, F, G in a different data set.
Therefore I need to write this without needing to specify the exact name of filters A, B, C, D etc; just specify to delete those rows in bulk, no matter based on what filter.
Your help would be much appreciated.
Also asked here VBA to delete rows hidden by filters
Last edited by a moderator: