excel vba代码，用于过滤包含列表中任何一个单词的列

I am new to vba code and have been doing some research and am not sure how to approach this project. I have a spreadsheet with 10 columns. I need to filter three of the columns. The filter would be a list of six words. For example, the three columns have groups of fruits in each cell. I would want to only show the rowd which have cells that contain apple, oranges, grapes, pears, kiwi, or bananas. If the cell does not contain any of these fruits then I would not want to see that row I have found some snippets of code to filter with two words but not more than that. Does anyone have any suggestions? I would greatly appreciate it. I am new to vba code and have been doing some r