Hi All
I'm looking to filter with the criteria being an array - can't quite get it to work.
Simple example below - where am I going wrong?
Thanks in advance!
Jon
I'm looking to filter with the criteria being an array - can't quite get it to work.
Simple example below - where am I going wrong?
Thanks in advance!
Jon
VBA Code:
Sub test()
Dim Narrative As Variant
Narrative = Array("*OPENING*", "*CLOSING*", "*VALUE*")
Range("A2:H100").AutoFilter FIELD:=4, Criteria1:=Narrative
End Sub