Delete a ROW in EXCEL
 

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 an
every4 th , 15th and 20th row is empty .
how to delete it with a single code

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48345

Delete a ROW in EXCEL
 

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

Delete a ROW in EXCEL
 

That would be (or like) if you can base the deletion on one column.
You certainly would not want to select all cells in a worksheet and
delete any row that has a empty cell within the used range.

If you want to delete all rows that are entirely empty based on
COUNTA use the macro at
http://www.mvps.org/dmcritchie/excel...emoveEmptyRows

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Niek Otten" wrote ...
EditGo to,Special, select Blanks
EditDeleteEntire row

"jayender.vs" ...
how to delete a row if the entire row is empty in Excel ?