LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Rows Between Empty Cells Daren Excel Worksheet Functions 6 September 8th 08 04:19 PM
Deleting empty rows automatically Bigweed Excel Discussion (Misc queries) 2 September 13th 06 09:39 PM
Deleting All Empty Rows bodhisatvaofboogie Excel Discussion (Misc queries) 3 May 18th 06 12:36 PM
Deleting unwanted and empty rows.... Jim New Users to Excel 3 July 5th 05 05:21 AM
Deleting unwanted and empty rows... Jim Excel Discussion (Misc queries) 2 July 4th 05 11:12 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"