View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 58
Default AutoFilter defect or my mistake?

On Jun 2, 11:51 am, ShaneDevenshire
wrote:
You need column titles, if you don't use them then the first row of data is
assumed to be the titles.


Thanks. I suspected as much, and I should have tested that hypothesis
first. But I thought my example with Custom selection was "proof"
enough. Sigh, I guess not!

FYI, if the selected AutoFilter range has __two__ blank rows, then the
sort fails altogether with an error (pop-up).