I create a report worksheet that varies in length. The report includes "*Phase" title rows that may or may not include data rows before the next title row. I want to delete the title rows that do not have data rows following the title row. The cell in column C of each title row has the text "*Phase". How do I write the code to delete the row if the text "*Phase" in cell C of the row equals the text "*Phase" in cell C of the row immediately following? The report worksheet has a header row that does not list *Phase in the header for column C.
This question generated 11 answers. To proceed to the answers, click here.
This thread is current as of April 29, 2017.