Filter data in column Excel VBA

[Colvic]

Can some help me and create a macro that picks out sentences with a particular letter combination in Excel Macro.

In column A it may be sentences that contain "IT" and I wants this sentence to be shown.

Ex: "is the largest IT community

Have gone so far: Selection.AutoFilter Field: = 2, Criteria1: =
but how do I do the remaining?

Many thanks.

 

[SkipVought]

Hi,

Go to your sheet.

Turn on your macro recorder.

Record setting the AutoFilter CRITERIA for Contains IT

Observe your recorded code.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]