| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error msg on Advanced Filter | Excel Discussion (Misc queries) | |||
| Advanced Filter - error message | New Users to Excel | |||
| Error using Advanced Filter Unique Records | Excel Discussion (Misc queries) | |||
| advanced filter error 1004 | Excel Programming | |||
| Error on advanced filter vba excel - 1004 | Excel Programming | |||
Linear Mode
