For example Delete_Rows(Sheets(“Sheet1”).Range(“A1:E23”,”Dog”) will delete all the rows in the range A1:E23 where the value in Column A begins with the word “Dog”. Note the use of Ucase means that the formulae is case INSENSITIVE i.e cells that begin with any of DOG, Dog, DoG or dog will all be deleted.

This:

Will become:

ABOUT AUTOMATE EXCEL

"At Automate Excel we offer a range of free resources, software, training, and consulting to help you Excel at Excel. Contact me to learn more."