AdvancedFilter Method in Excel 2000 vba 1

[corsair2]

I'm trying to filter (unique records) and copy a range using vba which I have previously named (again using vba).
I'm using the "AdvancedFilter" method and the filter works fine except that the first entry in the original range is always duplicated in the filtered list.
Any ideas?

 

[Dreamboat]

Are you sure that first entry is the first entry and not field names (column headings) that are being returned? Perhaps your code needs to be changed slightly? I don't do VBA, but I've heard of this behavior and it turned out to be something stupid like they had freeze panes on or somehow the column headings were being returned like they were data. Sorry I can't remember.
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[JVFriederick]

I think the advanced filter is looking for, and assumes you will have, a header row for your data.

If the header is excluded from the source range you will still get a "duplicate", but it should be the first desired record.

Let me know if this works for you.