I'm trying to figure out a way for a macro to search row by row. It will check columns C, D, and E to see if the row below it has the same values. If row 2 has the same values as row 1 then it will check columns a and b in row 2 to see if it is empty. If it is empty then the entire row 1 will be highlighted and row 2 will be deleted. This macro will continue until the program finds 4 empty rows in a row. Any help is greatly appreciated.