check data in column

i am facing a problem here. how to check some data in column "a",
For example,
Below are the data in my column "a"

Column "a"
com a
compl funct
sys func
sys completed
completed trace
func compl2
func com
sys trace
trace funct
trace compl

so i want to delete the row which column "a" hv come out a word "com"
so below is my coding,

Please Login or Register  to view this content.

so how to check the data if the "com" word come out in column "a"?
below is the result i want,


Column "a"
com a -to be delete
compl funct -to be delete
sys func
sys completed -to be delete
completed trace -to be delete
func compl2 -to be delete
func com -to be delete
sys trace
trace funct
trace compl -to be delete

if for the sql the coding can write as below,

If Cells(z, "a").Value like "%com%" Then

but for the marco, can some1 please assist me?
thanks.