VBA Code IF AND Statement

[Stjtoth]

I run a report everyday that puts the the word "NULLIFIED" in either column "L" or "M". I would like to create a macro that would delete the a row that has the word Nullified if nothing else appeared under the columns G, H, I, J, K, L, M, or N in that row, however if there is other data under these columns, I would only need to delete the word NULLIFIED.

This is done to clean up the data received. How can I create a macro that will delete the row if the word "NULLIFIED" is under the columns "L" or "M", but only deletes the word NULLIFIED if there is data under in the row under the columns G, H, I, J, K, L, M, or N.

I hope this makes scenes. Please let me know if you have any questions.

Thanks in Advance!

 

[jorismoerings]

Hi and welcome to MrExcel,

Just clarification:

puts the the word "NULLIFIED" in either column "L" or "M"

This doesn't match with your requirements of

if nothing else appeared under the columns G, H, I, J, K, L, M, or N in that row

because in L or M will be the word 'NULLIFIED".

So do you only want to delete the word nullified or do you want the complete row deleted if there's no data in the column G, H, I, J, K, or N?