Trouble deleting entire row fr a range based on text in one cell & value of 0 in another

I am fairly new to writing macros. I have been using the following code to delete rows from my worksheet when the text in column L meets the criteria defined in the code. I found this code online and tweaked it to work for my macro:

Please Login or Register  to view this content.

This code has been running successfully - deleting the rows that I would expect it to delete.

Now we need to add another criteria for consideration before deletion. The row should be deleted if the coumn L contains the text Tran to CPN, Settled, or PIF AND the value in column AF is 0 (zero - not blank). I tried to do a nesting if:

Please Login or Register  to view this content.

Now the rows are not deleting. Cell AF contains a formula. The results are truly 0 - not just rounding to 0. I even tested it by typing in a 0 in one of the cells rather than the formula and the macro still didn't delete the row. I'm not getting an error in VBA - it is running. It just isn't returning the desired results.

Please let me know if any additional information would be helpful. Thank you in advance for your help!!!

Kelly

Originally Posted by patel45

Please Login or Register  to view this content.

Thank you for the quick reply. My only concern with that suggestion is that I think it would delete rows with a value less than 0. We could have values in that column less than 0 that I would not want to delete.

Originally Posted by kmarshall6576

Thank you for the quick reply. My only concern with that suggestion is that I think it would delete rows with a value less than 0. We could have values in that column less than 0 that I would not want to delete.

I changed your < 0.01 to = 0 and it worked! THANK YOU SO MUCH!!!! I'll mark this solved!