A form contains a list box with 3 columns in it, (Number, First, Last). when
the user clicks the listbox, a macro runs that does advanced filtering on the
list. The criteria range gets filled with the values of first and last (not
everyone has a number) from the list box's 2nd nd 3rd columns, then the
Range("Ledger").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("Criteria"), Unique:=False
ledger refers to the entire data table, including the column headings, and
criteria is the criteria range.

The problm i am having is that this is not returning all of the records for
my name in the list, just the last of three. and yes, everything is spelled
exactly the same. does anyone know why this is filtering out data???