+ Reply to Thread
Results 1 to 9 of 9

Run-time error 1004: The extract range has a missing or invalid field name

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    London
    MS-Off Ver
    2017
    Posts
    5

    Post Run-time error 1004: The extract range has a missing or invalid field name

    Hello all.
    I'm trying a VBA formula to filter data. I'm stuck because I cannot comprehend what Excel wants. Here's the formula

    Sub CodingFiterData ()
    range ("MasterData").AdvancedFilter action:=xlFilterCopy, criteriarange:=range("Criteria"),copytorange :=range("Hasil"), unique:=false
    End Sub

    Then when I strated the formula, notification appears like this
    VBA Error Notification.png
    debug Error Notification.png

    Can anybody see anything immediatley wrong?

    Thanks

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    It's usually an issue with the workbook layout, not the code - e.g. the range you are copying to has a header that does not match a header in the source range.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    09-15-2020
    Location
    London
    MS-Off Ver
    2017
    Posts
    5

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    Hi Rorya,
    Thank you for your advice, but I still couldn't find the range problem

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    Nor can I, since I can't see your workbook...

  5. #5
    Registered User
    Join Date
    09-15-2020
    Location
    London
    MS-Off Ver
    2017
    Posts
    5

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    Sorry I can's attach the worksheet, so here's the capture file
    Attachment 695459
    Attachment 695460
    Attachment 695461
    Attachment 695462
    Attachment 695463

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    see big yellow banner - how to attach your workbook

  7. #7
    Registered User
    Join Date
    09-15-2020
    Location
    London
    MS-Off Ver
    2017
    Posts
    5

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    Sorry but i don't get what you mean

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    the attachments you have attempted to upload are invalid.
    there is a large yellow banner giving instructions how to upload because the paperclip attachment does not work
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  9. #9
    Registered User
    Join Date
    07-05-2025
    Location
    Armidale, Australia
    MS-Off Ver
    2013
    Posts
    1

    Re: Run-time error 1004: The extract range has a missing or invalid field name

    Exuming this post just to mention that you might also get this error if you've accidentally or deliberately hidden a column which contains one or more of the fields. I didn't see any other replies in Google to the same effect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Advanced Filter - extract range missing or invalid field name
    By sorensjp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2019, 04:07 AM
  2. Runtime Error 1004; The extract range has a missing or invalid field name.
    By ElStar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2018, 06:13 PM
  3. run-time error 1004 pivot table field name is not valid
    By OmerBD in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-16-2018, 08:47 AM
  4. excel run-time error 1004 pivot table field name is not valid
    By kentiq13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2016, 08:36 AM
  5. extract range has a missing or illegal field name
    By Drexl27 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-09-2015, 11:31 AM
  6. Error: THE EXTRACT RANGE HAS A MISSING OR ILLEGAL FIELD NAME
    By Min22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2012, 03:40 PM
  7. Keep getting an Range Missing or Illegal Field name error
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2012, 07:07 PM

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