I have recently recieved help on deleting rows that do not have the YES quantity in a certain coloumn. Is there anyway to keep the title row/Header row? Attached pictures are as explained. First is before i run macro and highlighted row is the row i want to stay. Second picture is how it looks after the macro is ran. 

Thanks.