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

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Claret" wrote in message
...
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?