Delete rows in a workbook that contain the same information
 

I'm working on an excel sheet and it has rows that have 0's throughout it.
I'm wondering if there is a way to delete all the rows that contain 0's
throughout the sheet without having to go to each row individually.

Delete rows in a workbook that contain the same information
 

In a spare copy .. Try autofilter. Choose: zero (your criteria) from the
autofilter droplist for your key col. Then select the filtered rows (the blue
row headers), right-click Delete. Remove autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"tiff" wrote:
I'm working on an excel sheet and it has rows that have 0's throughout it.
I'm wondering if there is a way to delete all the rows that contain 0's
throughout the sheet without having to go to each row individually.

Delete rows in a workbook that contain the same information
 

This deletes rows with 0

Sub deleteifzeroonanyrow()
For i = 1 To 10 ' last row to look in
lc = Cells(i, Columns.Count).End(xlToLeft).Column
If Application.CountIf(Range(Cells(i, 1), _
Cells(i, lc)), 0) 0 Then Rows(i).Delete
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tiff" wrote in message
...
I'm working on an excel sheet and it has rows that have 0's throughout it.
I'm wondering if there is a way to delete all the rows that contain 0's
throughout the sheet without having to go to each row individually.