AutoFilter Unknown Data in Loop with VBA code

[tuongtu3]

Hi,
I've found a thread in below and I would like someone help me to modify autofilter at cell CL13

https://www.mrexcel.com/forum/excel-questions/974450-autofilter-loop-vba-code.html

Regards,
tt3

 

[Michael M]

Just change it here

With Range("CL13", Range("CL" & Rows.Count).End(xlUp))

 

[tuongtu3]

Hi,
I got an error "Type Mismatch" at this line:

For Each Itm In aNames

Regards,
tt3