ExcelBanter - Advanced Filter Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Advanced Filter Error (https://www.excelbanter.com/excel-programming/351316-advanced-filter-error.html)

Claret

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?

Tom Ogilvy

Advanced Filter Error

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?

Claret

Advanced Filter Error

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?

All times are GMT +1. The time now is 02:31 AM.