I need a macro that will delete a row if there is any text in column A. For instance if there is any text written in cell A21 then the row 21 will be completely deleted. Thanks