Advancedfilter with multiple criteria?

Originally Posted by brucemc777

Simple: Six names and one month. But I think I have two fixes: either repeating the same month for all six cells in the second column or splitting the range as in Range("B1:B7, C1:C2")

Sounds like you're on the right track.