VBA - Delete Entire Row if Cell contains Text variable

[p45cal]

As recommended I attached a file so that it is easier to visualize the problem.

This is not a workbook file but a picture - it helps visualize but actually adds to the confusion since you've got what appears to be column headers A,B,C etc. which can't be in the sheet's actual columns A,B,C etc.; is that leftmost column actually column A of the sheet? You said as much in your first post, but if not, it's a good reason the codes wouldn't work. A workbook would be much more useful.