Well I tried a few solutions and only would up making more mistakes.
I need a function that will delete rows from a table I have on a worksheet. Basically if a cell from B2 down to B-whatever has the word "Delete" or "Delete2" in it I would like the that whole row deleted. Note I don't want the worksheet row deleted, only the row in the excel table. The data goes from B over to S.