VBA Excel Script to only show cells with certain characters (filter)

[noobhero]

0
down vote
favorite
I want an Excel VBA script to only show sells that contain any of the below characters:

?:!#$%&'*+/=?^,`<>{|}~;:?:%()»¢…&[]ä€\_’”"):
I found below script - but this only works on one of the above, and it's taking too long to use the Excel user-interface to put one of the characters at a time.

Here's the script I ahve that just filters one of the characters at a time - I want one that will filter to show all cells that contain at least one of these special characters:

Sub Macro1()
Columns("A:A").AutoFilter
ActiveSheet.Range("$A$1:$A$5").AutoFilter Field:=1, Criteria1:="=*>*", _
Operator:=xlAnd
End Sub

[Marc L]

As there is no special character, it's can be done without a code just using Excel basics
with a formula helper column returning TRUE or FALSE where you can apply a filter …

[noobhero]

This has a good tutorial on this ExtendedOffice.

But quite fiddly and time consuming. Would prefer a quick and dirty VBA formula if this is possible?

[noobhero]

Using the formula approach means Excel struggles to regnise ~, ? and *

But might be fix for this.