Delete row if value exists in cell

[taylorsm]

I want, if D=0 or Blank, delete row. I can't even figure out how to do it with a single value.

Nothing i find on google makes any sense to me


*Edit

If wasn't clear. If D3 was 0 or "" then D3 would delete. If D4 was 0 or "" then D4 would delete.

[PCI]

What do you mean by

then D4 would delete.

Just clear contents ???

Is it for column "D" or for any cell

[taylorsm]

Entire row.

D4 = 0 or "" then EntireRow.Delete
D5 = 0 or "" then EntireRow.Delete

I have this, and it works almost. It is deleting a lot, but then just suddenly stops. It isn't getting all the blanks. If I rerun it, it will filter and show the blanks, but it will only delete the first instance. I

With Sheets("Data").Range("E1", Range("E" & Rows.Count).End(xlUp))
.AutoFilter Field:=1, Criteria1:=Array("="), Operator:=xlFilterValues
.Offset(1).EntireRow.Delete
.AutoFilter
End With

[taylorsm]

Here is my exact code. If you run it you can see what I am talking about. It isn't deleting all the blanks.

Please Login or Register  to view this content.

[vcoolio]

Hello Taylorsm,

You need to clarify further. The sample in your post #1 has blanks or 0 in Columns D and E. Your sample in post #4 does not have any blanks or 0 in Columns D and E.

Cheerio,
vcoolio.

[PCI]

Here again the question about column reference: Is it column "D" to check or all columns ???

[daboho]

try this code i am has test if lot data untll 200.000 row is more faster if using filter

Please Login or Register  to view this content.

[taylorsm]

i'm sorry, i'm not sure where i'm losing everyone. The workbook and code should help. I am just deleting a row if the value in the "D#" cell is one of those options. Check value of D#, if value then delete THAT row. repeat through all

[taylorsm]

Hello Taylorsm,

You need to clarify further. The sample in your post #1 has blanks or 0 in Columns D and E. Your sample in post #4 does not have any blanks or 0 in Columns D and E.

Cheerio,
vcoolio.

If you run my code then it will. #4 is exactly what I start with, you run my code and it will delete select columns, THEN you end up with with the blanks/0 in the correct columns. Sorry my first post skipped a few steps, but I wanted to give the complete picture.



OK so issue relates to that E not having a value and therefore xlendup is stopping to soon. I can redirect it to look at A and will likely have no issues, but how do I locate the last row of data, regardless of column

[nigelog]

Please Login or Register  to view this content.

see if that helps

[taylorsm]

Type mismatch error

[jolivanes]

Works on your attachment in your first Post.

Please Login or Register  to view this content.