how can I delete rows based on column value
 

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

apply an autofilter to column C, filter on 0, and then just delete the
visible rows.

--
__________________________________
HTH

Bob

"mike" wrote in message
...
How can I delete certain rows of my worksheet that has a specific value in
a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

The following works for one "0". You can build a loop around this and use
FindNext() to locate others.

Option Explicit
Sub find()

Dim c As Range
Set c = Range("C:C").find(What:="0")
Rows(c.Row).Delete

End Sub


"mike" wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

PS. I like bob's idea better (just refreshed the page) :)

"mike" wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

That still deleted everything.



"StumpedAgain" wrote:

PS. I like bob's idea better (just refreshed the page) :)

"mike" wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

I gues I could just sort and delete, that's even simpler. I don't really need
to preserve thorder.

"StumpedAgain" wrote:

PS. I like bob's idea better (just refreshed the page) :)

"mike" wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

This shoudl do the trick.

Sub DeleteRows()

Dim i As Long
Dim LastRow As Long

LastRow = Sheets("Sheet1").Cells(Rows.Count, "C").End(xlUp).Row

For i = LastRow To 1 Step -1
If Range("C" & i) = 0 Then
Range("C" & i).EntireRow.Delete
End If
Next i

End Sub

--
Cheers,
Ryan


"mike" wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike

how can I delete rows based on column value
 

Sub DeleteRows_With_Zero()
FindString = "0"
Set b = Range("C:C").Find(what:=FindString, lookat:=xlWhole)
While Not (b Is Nothing)
b.entirerow.Delete
Set b = Range("C:C").Find(what:=FindString, lookat:=xlWhole)
Wend
End Sub


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 13:44:00 -0700, mike wrote:

How can I delete certain rows of my worksheet that has a specific value in a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike