View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] chiendh@uci.edu is offline
external usenet poster
 
Posts: 7
Default VBA: AdvancedFilter - Unique Copy of column of names doesn't work?!

On Mar 6, 4:26 pm, Debra Dalgleish wrote:
If you don't have a heading on the column, the first value will be
treated as the heading, and may appear twice in the list of unique
values. Could that be the problem?


Nope. I've got a NAMES header on the column in the actual (huge)
spreadsheet I'm writing. It's some sort of odd bug/behaviour in
Excel....