Delete blank rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi everybody,

I have a table contains of more than 500 rows, some of these rows are
filled and the others are blank, what I want is a code to help me
deleting the blank rows without selecting them one by one because it is
a time consuming way.

by the way, the blank rows are not under eachother, they are between
filled rows.

I hope that my question is clear for all,

thank you,


--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5186
View this thread: http://www.excelforum.com/showthread.php?threadid=401766

.

Relevant Pages

  • adding ".jpg" to an entire column
    ... I have a simple task that is very time consuming. ... GaryK ... GaryK's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25891 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Adding text file to a user form?
    ... I have tried the all and it really time consuming to read and write ... JaiJai ... JaiJai's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19484 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Sending sheets in workbook
    ... That is to time consuming if you have to do that for 14 different sheets ... billy2willy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21648 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • problem adding
    ... My spread sheet ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • need help with - time values...
    ... I would need the easiest way to find the time difference between the ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)