deleting empty rows

[EngelseBoer]

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

 

[Gord Dibben]

Select a column then F5>Special>Blanks>OK

Edit>Delete>Entire Rows.

You could record a macro whilst doing this.


Gord Dibben MS Excel MVP

 

[EngelseBoer]

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]

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

Gord