sub shanchu() s=[b2] for i=[a65536].end(xlup).row to 2 step -1 if s like "*" & range("A" & i) &"*" then rows(i).delete next end sub
