If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Advanced Filter - Unique Records Only shows 2 of the first value and is correct for the rest
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 |
Thread Tools | |
Display Modes | |
|
|