VBA Filter value part of of string

[jakobt]

Hi, want to create a macro to filter all cells in column K, which include the word "VAT Return".
The name vat return will be part of a string: For Exampe: Q1 2019 VAT return, or Q2 2019 Vat return.

Sub filtering

rows("1:1").select
selection.autofilter
activesheet.range("k4:k100").autofilter field:=1, criteria1:= "VAT Return", operator:=xlor

end sub

 

[Fluff]

Try

activesheet.range("k4:k100").autofilter field:=1, criteria1:= "*VAT Return*"

 

[jakobt]

Thumbs up!

 

[Fluff]

You're welcome & thanks for the feedback