AutoFilter Question

[JFulford84]

ActiveSheet.Range("$A$1:$N$247").AutoFilter Field:=2, Criteria1:=myList, _
        Operator:=xlFilterValues

What is wrong with this? MyList is a String Array.

This filters out all names in that range.

 

[JFulford84]

I guess a better question would be to ask how I take info from a list box and have it filtered.

I could be messing up the way I'm building the array. Can someone maybe give me an example of how to plug a list box, into an array, and then filter those results with AutoFilter?