Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

How to delete multiple rows?

Posted by Aaron on January 26, 2002 9:19 PM

I have a data spread sheet I would like to delete all rows which contains an empty cell (no data in them, they are on different rows and all over the spreadsheet)without going through manually clicking one by one (I have been using control/click) and deleting the rows, does anyone know how do I get it done in a simpler way? Thanks.

Try using Edit>GoTo>Special>Blanks

Posted by Puck on January 26, 2002 9:47 PM

Re: How to delete multiple rows?

Posted by Bariloche on January 26, 2002 9:51 PM

Aaron,

One of the subroutines located at this link should do the trick for you.

good luck

Re: Try using Edit>GoTo>Special>Blanks

Posted by Aaron on January 26, 2002 10:06 PM

Thanks guys! That simple trick does the job.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.