Delete rows in a workbook that contain the same information

  • Thread starter Thread starter tiff
  • Start date Start date
T

tiff

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.
 
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
 
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
 
Back
Top