Delete hidden rows using VBA and an array?

[LAAdams17]

I have a spreadsheet with thousands of rows. I need to delete the rows that are filtered out. Each solution I've tried so far takes forever to get this done. I'm thinking there may be a much faster way to get this done using VBA and an array (read active worksheet into an array, delete the hidden rows and then write the array back out)? Can anyone help with this? Thank you in advance!

 

[Peter_SSs]

What did you do about removing the blank rows?

Also, does your data only exist in column A?
If not what happens if there are filters on columns other than column A? I'm asking because if there is a filter on a column other than column A then the results may not be correct,

.. and did you try (& time) the post # 9 code?

 

[LAAdams17]

What did you do about removing the blank rows?

Also, does your data only exist in column A?
If not what happens if there are filters on columns other than column A? I'm asking because if there is a filter on a column other than column A then the results may not be correct,

.. and di you try (& time) the post # 9 code?

Since the rows are blank, for me it may not matter what column is filtered, but the first column in my dataset will always have info in it as it's the unique identifier. I did try the code from post #9, but found this other post much quicker.

 

[Peter_SSs]

it may not matter what column is filtered

In fact it doesn't. My comment about possible incorrect results in relation to that were wrong.
Anyway, glad you have a good solution.

 

[Akuini]

This by far is the quickest solution that I've found which works for me. THANK YOU!

You're welcome, glad to help & thanks for the feedback.