Hi Jim,

Have a look at this: http://j-walk.com/ss/excel/tips/tip56.htm

Regards,
KL


"Jim333" wrote in
message ...

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...fo&userid=5186
View this thread: http://www.excelforum.com/showthread...hreadid=401766