Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about AdvancedFilter
Set FilterRange = Range("E2:E5000")
FilterRange.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("J2"), Unique:=True I put data like this in column E, down to row 100, row 1 has the header "Number" Number 1 2 3 1 2 3 But when I run the code I get, why am I getting 2 number 1's ??? 1 2 3 1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about AdvancedFilter
Advanced filter expects the first row in the range to be the header.
Maybe you can use E1:E5000 or add headers, then include that row, too. Paul B wrote: Set FilterRange = Range("E2:E5000") FilterRange.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("J2"), Unique:=True I put data like this in column E, down to row 100, row 1 has the header "Number" Number 1 2 3 1 2 3 But when I run the code I get, why am I getting 2 number 1's ??? 1 2 3 1 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about AdvancedFilter
Dave, I do have a header row but I was not wanting to bring that data over,
but I can work around that, Thanks Paul B "Dave Peterson" wrote in message ... Advanced filter expects the first row in the range to be the header. Maybe you can use E1:E5000 or add headers, then include that row, too. Paul B wrote: Set FilterRange = Range("E2:E5000") FilterRange.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("J2"), Unique:=True I put data like this in column E, down to row 100, row 1 has the header "Number" Number 1 2 3 1 2 3 But when I run the code I get, why am I getting 2 number 1's ??? 1 2 3 1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA AdvancedFilter Question | Excel Programming | |||
Advancedfilter | Excel Programming | |||
AdvancedFilter in VB | Excel Programming | |||
AdvancedFilter Criteria question | Excel Programming | |||
AdvancedFilter question | Excel Programming |