Macro request to delete all rows between two specific text values whose rows are dynamic

[crab transplant]

Hello excel guru's,

I have a data output that has two text values which repeat in rows throughout the dataset, Text A and Text B.

The number of rows between Text A and Text B are dynamic, but Text A and Text B are always the bookends and always reside in Column C. What I am looking for is to delete the rows between Text A and Text B throughout the worksheet using a Macro. Additionally there are other rows, not between Text A and Text B that should not be deleted.

Additionally I would explain the problem as: For every instance of Text A, delete rows until instance of Text B. Then look for next instance of Text A and repeat.

I have tried, but failed to adopt these posts and macros http://www.mrexcel.com/forum/excel-...-between-two-other-rows-certain-criteria.html and http://www.mrexcel.com/forum/excel-questions/6483-delete-rows-between-two-specified-values.html as I am a Marco Noob.

Thank you in advance for your assistance.

 

[yomerves]

I will test this method. I was also able to find a solution using InStr. Thank you very much for your help!