+ Reply to Thread
Results 1 to 7 of 7

Run Time Error 1004 when using Application.index method

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Run Time Error 1004 when using Application.index method

    Hi Guys,

    i can not unfortunately share the data but my code is looking like:

    Please Login or Register  to view this content.
    In bold part it is working and outputting like a charm data like here:

    Screenshot_26.png

    In the other b key in subdictionary there is the same structure but giving the erro from topic:

    Screenshot_27.png

    Why is this happening?
    I red that if you are using index on more than 65 000 rows you cna have error but in this case we have 8 x 6 = 48 variables.

    Why? Can anybody help?

    Please,
    Jacek

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Run Time Error 1004 when using Application.index method

    If any one element have more than 255 character or error value, it will fail.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Run Time Error 1004 when using Application.index method

    Thank you jindon very much!

    ah so in this case how can i solve it?

    I thought to use error handler and output row by row?

    Something like here:

    Please Login or Register  to view this content.
    but still if i have 255 character it will fail?

    Can you help how to loop?

    Jacek

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Run Time Error 1004 when using Application.index method

    only 36 elements?

    Output directly to the cells or prepare temp 2d array, etc.
    Anyway, there is no way to handle such data I mentioned by Transpose/Index etc.

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Run Time Error 1004 when using Application.index method

    Yes but i can have formulas inside array which will exceed 255 characters so i have to handle it.

    How to output this directly if i have shape of array like in the screen above?
    Please help,

    Jacek

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Run Time Error 1004 when using Application.index method

    You have ArrayTest, so you can use it to make it easier.
    something like
    Please Login or Register  to view this content.
    Last edited by jindon; 03-13-2020 at 11:30 AM.

  7. #7
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Run Time Error 1004 when using Application.index method

    thank you very much jindon !

    Jacek

+ 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. Getting run-time error 1004 method 'undo' of object application failed
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2017, 08:07 AM
  2. [SOLVED] getting run time error 1004: method activeprinterof object application failed.
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2015, 03:12 PM
  3. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  4. Addon error : Run-time error '1004': Method 'MacroOptions' of object '_Application' failed
    By jtcoleman in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 02-05-2014, 12:23 PM
  5. Replies: 4
    Last Post: 11-15-2013, 05:03 PM
  6. VBA Code...error = run time error 1004 autofilter method of range class failed
    By Dariusd7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2013, 04:49 PM
  7. [SOLVED] run-time error '1004': Application-defined or object-deifined error
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2005, 05:05 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