nemmi69
Well-known Member
- Joined
- Mar 15, 2012
- Messages
- 938
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Using the code below I still get the entire list under the header even though a filter is applied for 'Devices'. Trying to find how to get just the filtered list.
VBA Code:
TblId.Range.AutoFilter Field:=3, Criteria1:= "Devices"
'
Aa = Application.Transpose(Evaluate("sort(unique(" & TblName & "[" & HEADERCAT1 & "]))")) 'Array of ITEMS