View Single Post
  #4  
Old September 2nd, 2004, 06:07 AM
L Mehl
external usenet poster
 
Posts: n/a
Default

Bob --

Thanks for pointing that out. I added column headers.

Problem remains ... the first value still appears twice.

dcronje --

Thanks for the "criteria" comment.

Larry


"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