Delete a ROW in EXCEL

[jayender.vs]

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?

[Niek Otten]

Edit>Go to,>Special, select Blanks
Edit>Delete>Entire row

--
Kind regards,

Niek Otten

"jayender.vs" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[David McRitchie]

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" <[email protected]> wrote ...
> Edit>Go to,>Special, select Blanks
> Edit>Delete>Entire row
>
> "jayender.vs" <[email protected]>...
> > how to delete a row if the entire row is empty in Excel ?