+ Reply to Thread
Results 1 to 3 of 3

Advanced Filter Error

  1. #1
    Claret
    Guest

    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. #2
    Tom Ogilvy
    Guest

    Re: Advanced Filter Error

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

    --
    Regards,
    Tom Ogilvy

    "Claret" <Claret@discussions.microsoft.com> wrote in message
    news:08F93C83-6927-466B-A788-4AB2DB14B6BA@microsoft.com...
    > 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. #3
    Claret
    Guest

    Re: 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" <Claret@discussions.microsoft.com> wrote in message
    > news:08F93C83-6927-466B-A788-4AB2DB14B6BA@microsoft.com...
    > > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1