VBA : Delete Blank rows

[ssingh75]

Dear All,

Can anyone please let me know the Macro to delete blank rows from entire sheet...

Thanks in advance..

Susheel Singh

 

[maahi777]

Here is the solution
How to Easily Delete Blank Rows in Excel Worksheet?

 

[hdshank]

When I click on the link, I get a 404 error.

 

[maahi777]

You can visit Meet Your Expert Here and paste How to Easily Delete Blank Rows in Excel Worksheet? in search box.. you will be redirected to the link.

 

[ghSea]

That's not a VBA solution, which was the original request.
Firefly's solution seems to be the fastest,
when AutoFilter/sorting blanks to the bottom doesn't work for some reason.
It still feels slow, when needing to delete half the rows in a selection of 450, which is my own challenge.
Am wondering if copy/clear/paste might be faster, or if using an Array would do it, but haven't yet found the code for deleting "rows" in arrays.

 

[kg0332]

Where do I place Firefly2012's Code? I got it to work once somehow. Closed my file without saving. Can't get to work again

 

[kg0332]

Where do I place FireFly2012's Code?

 

[ghSea]

No, this is not "the solution".
"The solution" will be in the form of a macro, which was the original query.