VBA - Delete Entire Row if Cell contains Text variable

[1580067]

Country	Variable 1	Variable 2
France	x	y
Italy	x	y
Germany	x	y
USA	x	y
France	x	y
France	x	y
USA	x	y
Germany	x	y
Japan	x	y

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 wouldnt work. A workbook would be much more useful.

You are right. I did not manage to link a file. I created this table. Hope this helps.