mtm70, Modified & attached altered worksheet that (I think) will work for you. The lines numbered 101-103 & 110 are the altered lines. The fix involved dealing with the expanded version of 'operator' and using [IsEmpty()] instead of [= ""] to work with arrays for the "Criteria1" variable. Holler back if this doesn't work for you. sauerj
FilterSheets(2012-12-15).xls
Bookmarks