I have a worksheet with about 5,000 lines. When I try to autofilter on a
selected item from the dropdown menu, it displays many more cells that don't
contain that value (including blank cells) and indicates only 1 line was
found. I've never encountered this problem before with autofilter.

BTW, in case it means anything, the workbook was originally a shared
workbook. I "unshared" it before applying the autofilter. And, I did try to
copy and paste special, values only, into a new workbook. Same problem and
results.

Any thoughts from anyone? Thanks in advance.