I fixed the duplicate first category problem by giving that column the name
"Category", so that it became the first result, and locating the
CopyToRange:=Range so that "Category" appeared in the same row as headers
for the statistics I calculate for each category.
Thanks again for the responses.
Larry Mehl
"L Mehl" wrote in message
...
Hello --
I want a list of unique values in a column (one column in a worksheet) for
further processing.
I use Advanced Filter - Unique Records Only in a recorded macro and it
correctly processes the list, except for showing the first value twice;
the
remaining unique values are correct.
Macro code is:
Range("app_category").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("criteria"), _
CopyToRange:=Range("extract"), _
Unique:=True
Values in the source column "app_category" are sorted.
The Criteria range is two stacked cells; the top cell is named "criteria";
the cell below that is blank.
The Copy To range is named "extract" and is blank. I did not enter a
column
name because only one column is being processed. If I enter the column
name
there, the macro generates the error "The extract range has a missing or
illegal field name."
Can anyone suggest what is causing the duplicate of the first entry?
Thanks for any help.
Larry Mehl
|