Delete blank rows

[Noz2k]

Is this a way in excel, or by using VBA to quickly delete all blank rows in a worksheet?

I have a few sheets with hundreds of thousands of rows of data and half the rows are blank and unneeded.

 

[Jonmo1]

If you can pick a column that will determine if a row is blank..
I.E.
If The cell in column A is blank, then it can be assumed that the entire row is blank..

Then

Highlight Column A
Press CTRL + G (or click Edit - Goto)
Special
Blanks
OK
Right click any highlighted cell
Delete
Entire Row
OK

Hope that helps.

 

[Noz2k]

That should do the trick, thanks very much