excel - if active cell contains text

Question

I am looking for a VBA code to filter the cells that contain 'FAG'

Example: ACIDE ACETYLSALICYLIQUE 1KG FAG

So I want to select all the cells with FAG in it. Found something but it doesnt work.:

ActiveCell.Value(0, 1).like = "FAG" I get error 9, subscript i out of reach

Answer 1

等待大神答复