I keep getting the mismatch error on my variables. All of the variables are chosen by the user from a drop down list, so AZ1:BA1 is a merged cell with a drop down list to chose from. Same for the other variables. I know the merged cells are not the problem because I tested it with out merging. The premise is that the user selects from three criteria from drop down boxes (Date, Serial Number, Component), then a macro applies those to an autofilter for the results. Thanks for the help. - Luke 

Please Login or Register  to view this content.