If Statement that checks two cells

Hi Ladies and Gents,

I am trying to check a cell to see if it contains "Deactivation" and if it does check to see if the cell next to it contains "Prepaid" if both are true delete the entire row if either one is not true move on to the next.

Attached is a sample of my data (some columns blanked out for security reasons.) The code i have currently just deletes anything that is a deactivation.

Please Login or Register  to view this content.

Any help greatly received.

Thank you in advance

Rich

change one line of your code

Please Login or Register  to view this content.

Thanks Kamboj works a treat.