Advanced Filter Error

[Guest]

Hi, I have recorded a macro as follows:

Range("O5:X200").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"A33:J35"), CopyToRange:=Range("A36:J36"), Unique:=False

but when I run it I get:

Runtime error 1004
The extract range has a missing or illegal field name

Can anyone plese help?

 

[Tom Ogilvy]

does A36 to J36 contain the column header/field names of the source data?

 

[Guest]

it did, but I've tried deleting them and now it works, thanks!