deleting empty rows
 

the scripts i am running for returned results are such that there are dozens
to 100's of empty rows - as i am dealing with a page conting almost 37,000
rows;
manually deleting the empty rows so that the returned info is more legible
is a pain -- for real -
i typically save as delimited then copy the delimited back to active so i
can work with the data futher -

what script can i run to auto delete empty field rows please

deleting empty rows
 

Select a column then F5SpecialBlanksOK

EditDeleteEntire Rows.

You could record a macro whilst doing this.


Gord Dibben MS Excel MVP

On Sat, 6 Sep 2008 16:20:01 -0700, EngelseBoer
wrote:

the scripts i am running for returned results are such that there are dozens
to 100's of empty rows - as i am dealing with a page conting almost 37,000
rows;
manually deleting the empty rows so that the returned info is more legible
is a pain -- for real -
i typically save as delimited then copy the delimited back to active so i
can work with the data futher -

what script can i run to auto delete empty field rows please

deleting empty rows
 

THANKS
i wish i had asked yesterday now, BEFORE getting repetitive strain injury
(well it feels like it
spent HRS scroling down and manually deletin

thaks a bunch Gord

"Gord Dibben" wrote:

Select a column then F5SpecialBlanksOK

EditDeleteEntire Rows.

You could record a macro whilst doing this.


Gord Dibben MS Excel MVP

On Sat, 6 Sep 2008 16:20:01 -0700, EngelseBoer
wrote:

the scripts i am running for returned results are such that there are dozens
to 100's of empty rows - as i am dealing with a page conting almost 37,000
rows;
manually deleting the empty rows so that the returned info is more legible
is a pain -- for real -
i typically save as delimited then copy the delimited back to active so i
can work with the data futher -

what script can i run to auto delete empty field rows please

deleting empty rows
 

Good to hear........about the results of the F5 trick........not about the
RSI

Gord

On Sat, 6 Sep 2008 16:53:02 -0700, EngelseBoer
wrote:

THANKS
i wish i had asked yesterday now, BEFORE getting repetitive strain injury
(well it feels like it
spent HRS scroling down and manually deletin

thaks a bunch Gord

"Gord Dibben" wrote:

Select a column then F5SpecialBlanksOK

EditDeleteEntire Rows.

You could record a macro whilst doing this.


Gord Dibben MS Excel MVP

On Sat, 6 Sep 2008 16:20:01 -0700, EngelseBoer
wrote:

the scripts i am running for returned results are such that there are dozens
to 100's of empty rows - as i am dealing with a page conting almost 37,000
rows;
manually deleting the empty rows so that the returned info is more legible
is a pain -- for real -
i typically save as delimited then copy the delimited back to active so i
can work with the data futher -

what script can i run to auto delete empty field rows please