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

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

On Oct 22, 7:57*am, James8309 wrote:
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

Hi,

Can you please verify these links.
http://www.lytebyte.com/2008/02/28/h...-office-excel/
http://www.digdb.com/excel_add_ins/d...olumns_sheets/

I hope this will help you.
--
Anuma Reddy
http://www.GGKtech.com



"James8309" wrote:

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

Try select column A and F5SpecialBlanksOK

EditDeleteEntire Row

Record a macro whilst doing.


Gord Dibben MS Excel MVP

On Tue, 21 Oct 2008 23:57:06 -0700 (PDT), James8309
wrote:

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

On Oct 23, 4:51*am, Gord Dibben <gorddibbATshawDOTca wrote:
Try select column A and F5SpecialBlanksOK

EditDeleteEntire Row

Record a macro whilst doing.

Gord Dibben *MS Excel MVP

On Tue, 21 Oct 2008 23:57:06 -0700 (PDT), James8309
wrote:



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- Hide quoted text -

- Show quoted text -

When I do this;

Try select column A and F5SpecialBlanksOK

EditDeleteEntire Row


It says "Selection is too large"

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

On Wed, 22 Oct 2008 15:28:24 -0700 (PDT), James8309
wrote:

When I do this;

Try select column A and F5SpecialBlanksOK

EditDeleteEntire Row


It says "Selection is too large"