Filters

[Peteor]

Hello! I believe I am way over-complicating this... I want to filter across all Worksheets for a substring within a cell, but my code only filters for a string. The criteria sub-string is not the only text within the respective cells. Essentially I want to say "If Cell contains value, Filter across all sheets" rather than "If cell equals value, Filter across all sheets". Any Advice?

Sub apply_autofilter_across_worksheets()
Dim xWs As Worksheet
On Error Resume Next
For Each xWs In Worksheets
xWs.Range("A1").AutoFilter 1, "=KTE"
Next
End Sub

 

[Fluff]

If it's part of a cell use "*KTE*"

 

[Peteor]

Yea, sorry Fluff.... I posted this, then realized I can use Macro Recorder here to get what I need. I set it to Record, went to text filters, checked "contains", and viewed the code. Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.