Removing Blank Rows From Large Spreadsheets

[Henner]

Hi,

I receive 12 large spreadsheets every day that can up to 50,000 rows of data each, in 4 columns, but they frequently also have many blank rows at non-regular intervals as well.

I need to remove the blank rows but Auto-Filter isn't very useful.

Could anyone please provide me with another way of removing them that I could put in a macro?

Thanks,
Paul Hemnner

 

[Juan Pablo González]

How about sorting ?

 

[PaddyD]

Paul,

download the asap addin from

http://www.asaputilities.com

eit has a function (under the Columns / Rows menu) for conditional hide / delete rows & cols. One of the option is to delete completely empty rows.

Paddy