Advanced Filter Error

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?

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

--
Regards,
Tom Ogilvy

"Claret" <[email protected]> wrote in message
news:[email protected]...
> 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?

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>