I'd have to be a sample to be sure. My first idea, if my code is failing on the Autofiltering, then I would create a temporary values-only copy of the sheet first.