Hi
I am attempting to filter a table in a worksheet to show only the values included in an array.
The above filters the table column in question but only using the first element in the array instead of all array elements. Any ideas?
Many Thanks
Mosiki
I am attempting to filter a table in a worksheet to show only the values included in an array.
PHP:
aryFilter() = wsSP.Range(Cells(1, 1), Cells(lSPLastRow, 1))
wsLV.ListObjects("tbl_LV_DATA").Range.AutoFilter Field:=lSec_Type_Col, _
Criteria1:=aryFilter(), Operator:=xlFilterValues
The above filters the table column in question but only using the first element in the array instead of all array elements. Any ideas?
Many Thanks
Mosiki