Reply to thread

Message: [QUOTE="Peter Bernadyne, post: 2779195"] Hello, This is a weird one that's never happened to me before. I am using autofilter on what is a fairly substantial worksheet. Fo whatever reason, when I filter on one of the elements in a colum (which should return well over 8,000 rows) I instead keep getting muc smaller numbers (like 62 or 68 or something). There are no breaks i the column (everything is contiguous) and, as far as I can tell, th elements appear in the autofilter drop-down list just fine. The only thing I can think of is that I'm having some sort of memor problem, given that I have a fairly substantial worksheet of 60,00 rows (columns:A-U). Does anyone know why my autofilter would be failing me? Is there a upper limit of memory/rows after which autofilter does not work? Any help much appreciated! Thanks, -Pet [/QUOTE]