Mike, Yup, it's strange.

What actually happens is that rows get filtered out and Excel refuses to "show all" when asked. If Excel hadn't refused to "show all", I probably wouldn't have noticed. Rows go missing on other sheets, too.

I've found that Microsoft's suggested work-around, turning off AutoRecalc and then manually undoing the filter, works so I'm preemptively doing that.

I updated the macro to turn off the AutoRecalc, run the autofilter for unique records, count unique records and, if that is less than the total records, continue on to "show all" etc. However, if all records are unique records, I bypass the rest of the macro because there's nothing to delete and that's problematic, too.

Susan