Whenever VBA encounters your given text in the specified column, it will erase the entire row where that text was located. Click the "X" in the top right corner of the editor to close it.