VBA filter columns by values and wildcards

[DutchKevin]

Hello All,
For a table that i have I use below code to filter based on column titels. Showing only columns that meat the criteria in row 8.
However this currently only works for an exact match (I already managed to get around the case sensitivity).

I would need a code that filters for part of the vaulue.
Lets say I enter "Text1" as a search criteria in cell C8, I need the code to show all colums where in row 8 the "text1" is part of the value. So showing also "text11" and Text1A" for example.
I can't get my head around how to use the wildcards properly.
Do you have any suggestions??

Thanks
Kevin

            If (LCase(Cells(8, n).Value)) = LCase(Range("c8").Value) Then  'note the explicit Lowercase command
                Cells(8, n).EntireColumn.Hidden = False
            Else: Cells(8, n).EntireColumn.Hidden = True
            End If

 

[VoG]

Perhaps like this

            If LCase(Cells(8, n).Value) Like LCase(Range("C8").Value) & "*" Then  'note the explicit Lowercase command
                Cells(8, n).EntireColumn.Hidden = False
            Else: Cells(8, n).EntireColumn.Hidden = True
            End If

 

[DutchKevin]

Hi Peter,
Thanks for the try, but it's not producing any results on the filter. Outcome is empty so to speak.
I had myself also tried various options with the [& "*"] but also without results.

Also this one has same effect.

            If (LCase(Cells(8, n).Value)) = LCase(Range("*" & "c8" & "*").Value) Then            'note the explicit Lowercase command
                Cells(8, n).EntireColumn.Hidden = False
            Else: Cells(8, n).EntireColumn.Hidden = True
            End If

BR
Kevin

 

[VoG]

Then maybe

            If LCase(Cells(8, n).Value) Like "*" & LCase(Range("C8").Value) & "*" Then  'note the explicit Lowercase command
                Cells(8, n).EntireColumn.Hidden = False
            Else: Cells(8, n).EntireColumn.Hidden = True
            End If

 

[DutchKevin]

Thanks Peter! that worked!
The "like" did the the trick.

Merry Christmas and a happy new year to you and all other readers!