title: Delete entire rows based on a value contained in the row with macro?
body: <p>I have a spreadsheet which contains a whole bunch of text and number values.  I would like to have a macro search the sheet, select the rows containing the word "Total" and delete the entire row.  I have been searching for hours and have not found any code that I can adapt to perform this task.  I have a little experience with VBA but am out of practice and patience.  The word is not case sensitive and may be contained in a string of text, for example: "Total for 12345 Jane Doe".</p>