Why don't you use advancedfilter with xlfiltercopy ?