Code for advanced filter producing run time error

[Texas Longhorn]

I have the following:

Sub Macro2()

    Sheets("AggregateQ4Pipeline").Select
    Range("AggregatePipeline").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Range("A1:V2"), CopyToRange:=Range("A5"), Unique:=True
End Sub

For some reason, when I run it, I get the following runtime error:

Run-time error 1004

The extract range has a missing or illegal field name.

I'm not sure what I've done wrong: I've checked the headings of the source data, and copy/paste valued them into AggregateQ4Pipeline! (the output page). They definitely match.

Here they are, in case that matters (I'm posting them vertically even though they're across row 1 in my sheet just so they fit better on the board):

Closed vs Beg Pipeline Q4.xls
	A	B	C	D
1	Company
2	CompID
3	Worknote
4	ID
5	Quarter
6	Month
7	Rep
8	Manager
9	MaxUserAcct
10	Stg
11	GR
12	Mgr
13	Prod/Serv
14	ProductRev
15	SvscRev
16	MaintRev
17	DiscPercent
18	Competition
19	Country
20	City
21	State
22	Director
Sheet1

Any help would be great.

Thanks,

Bill

 

[Juan Pablo González]

Are the ranges A1:V2 and A5 in the sheet 'AggregateQ4Pipeline' ?

 

[Texas Longhorn]

Oops! There's the error. Thanks Juan...my apologies for being so careless. I should get more sleep.

Thanks,

Bill