VBA To Delete Hidden Rows for a large set of data

[pliskers]

I've found several versions of code to delete all hidden rows within a worksheet, but each of them is a loop that evaluates each row one by one. With a worksheet such as the one I'm working with, with tens of thousands of records, this is not a usable solution due to the amount of time it takes to cycle through the entire data set.

Is there another way to do that that would capture and delete the hidden rows in more of a single step approach? Conversely, would something work faster if I hid only the records I want to keep and have the code delete all visible rows?

I'm stumped! Thanks for any help,

 

[JEC]

Is there any condition which has to be met before you hide rows?

 

[pliskers]

Is there any condition which has to be met before you hide rows?

I should have clarified. By "hidden", I'm referring to rows that are filtered via a slicer and therefore not visible. They are not literally hidden.