Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I am trying to do an extract of data based on criteria. It has worked fine until I made a minor change.
    Now I get an error saying:
    The extract range has a missing orillegal field name.
    I have deleted all the range names and re-created them but keep getting the same error.
    Help Please!!

    Thanks,

    itconc

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    What was the minor change you made?

    It would help if you could attach a copy of the workbook with sensitive information removed or altered.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It sounds like one the headings in the header row has been deleted.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='785112' date='17-Jul-2009 12:56']What was the minor change you made?

    It would help if you could attach a copy of the workbook with sensitive information removed or altered.[/quote]

    Thanks to both of you.
    Before I got ready to attach the file, I re-did all the column headings and lo and behold that was the problem. The minor change was to add a data series and adjust all the dynamic ranges I had.
    Anyway, all is working again.
    Thanks again!

Posting Permissions

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