@p45Cal

Thanks Brother, the above code works, except what is sought at Serial No. 5,6,7 in post #1, however is not done properly. I mean where there is no pair of row having data in Column E "YY", followed (subsequent row) having "ZZ" is not deleted.