Advanced Filter Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Back
Top