View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default autofilter fails, not because of blank row

A co-worker asked me to look at his spreadsheet and try to fix his
autofilter. The autofilter would only select down through row 30 while
his data went down to row 70 or something. There was no blank row in
the dataset. I tried removing and reapplying the autofilter, same
problem. Are there other conditions that cause autofilter to not
select the full data range?


John Keith