Delete Rows Multiple Criteria w/Numbers

I am trying to use the code below to eliminate data in a spreadsheet based on certain criteria. I have been able to get this to work with text fields just fine, but now I am running into an issue with numbers. I am trying to get this code to delete rows if they have the word "unknown" in column C and if the value in column B is greater than 900 hours (999:00:00), the numbers in this column are formatted as [hhh]:mm:ss. What should I tweak to make this work?

Please Login or Register  to view this content.

Hi,

1. Have you set the variable Last_Row somewhere?
2. Take out the double quotes around the 900.

However I can't help thinking that you'd be better filtering the data and then deleting the filtered rows rather than doing this with a loop. Loops are fine if the data set is relatively small, but with larger data sets you'll find they are much slower than using in built Excel functions such as data filter.

HTH

Your code,

Please Login or Register  to view this content.

indicates that the values in column B are all text values. Is this the case, or do the cells contain numbers for calculations? If these are meant to be numbers and not text strings then the quotes must be deleted ( 900 is not "900"):

Please Login or Register  to view this content.

Also, I'm not sure from your description whether both conditions must be true or if you want the row deleted if either is true. Do you want the row deleted if either B is greater than 900 OR C is Unknown?

Try this:

Please Login or Register  to view this content.

You're welcome.

I agree with Richard's comment, BTW.