Deleting Empty Rows

[James8309]

Hi everyone,

I have about 100 text files containing large amount of data.

when I paste it into excel 2007 it is like below;

Column A


DATA~~~~~~~

BLANK ROWWWWWWWWW

DATA~~~~~~~~~~

BLANK ROWWWWWWWWW
..
..
..
..


it goes on and on upto about few hundred thousand rows.

How do I use fast and effective macro to delete empty rows entirely in
column A:A?

Thank you for your help in advance.

Regards,


James

 

[paul.robinson]

Hi
Search this group using "How do I delete empty rows?" and there are
probably dozens of solutions.
regards
Paul

 

[Anuma(GGK Tech)]

Hi,

Can you please verify these links.
http://www.lytebyte.com/2008/02/28/how-to-delete-empty-rows-those-are-in-between-in-ms-office-excel/
http://www.digdb.com/excel_add_ins/delete_blank_hidden_rows_columns_sheets/

I hope this will help you.

 

[Gord Dibben]

Try select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row

Record a macro whilst doing.


Gord Dibben MS Excel MVP

 

[James8309]

Try select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row

Record a macro whilst doing.

Gord Dibben  MS Excel MVP









- Show quoted text -

When I do this;

Try select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row


It says "Selection is too large"

 

[Gord Dibben]

Is that the complete message?

I assumed Excel 2007 would be similar to Excel 2003 and earlier.

I guess with a "few hiundred thousand rows" Excel gets over-taxed?

I don't use 2007 so cannot test.


Gord