EditGo to,Special, select Blanks
EditDeleteEntire row

--
Kind regards,

Niek Otten

"jayender.vs"
wrote in message
...

Dude,
how to delete a row if the entire row is empty in Excel ?
i got many row empty in between .. like there are about 50 rows and
every4 th , 15th and 20th row is empty .
how to delete it with a single code?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483450