Hello,

I want my macro to delete any rows in a certain worksheet where the value in column A begins with an open parenthesis "(".

I've included an attachment to illustrate my question. In the example, row 13 contains a sort of total for each column. The number of groups in column A can change daily, so depending on the number of groups in the worksheet, the "total" row could be anywhere. I want to delete this row from the worksheet, and the only way I can think to distinguish this row from my pertinent data is that it will always begin with a "(" in column A. Alternatively, there will always be a space between the last line of data and this total row, so maybe there's a way to use that to pare off the bottom "total" row?

Thank you very much for reading my question.

-Student1990IDRowandDelete_MACRO.xlsx