View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Worksheet fails to filter at times

I have a large workbook - 25meg - and occassionly the autofilter fails to
work. I have to cancel autofilter, unhide rows, and reset autofilter. The
main worksheet I usually filter has some blanks, and is almost 3000 lines
long, so resetting can be a pain. Any suggestions?
--
JB