+ Reply to Thread
Results 1 to 2 of 2

VBA INdex Match generating Error 1004

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,391

    VBA INdex Match generating Error 1004

    "Parameters" sheet has three strings in A6 - A8,

    "Spread" sheet has every possible permutation of those strings in Cols A and B.

    Starting in row 6, the Code should find the matching strings in "Parameters", copy the two values for each week in turn, post them into Cols X and Y, Col O then divides X by Y, and moves to next column and find the values for that week.

    But it throws an error 1004 when it comes to calculating value of "j.Offsets"

    Tried every permutation of brackets I can, but simply missing something obvious

    K17 - V22 shows what the output should be.

    Please Login or Register  to view this content.
    Any suggestions, solutions or alternatives welcome as ever

    Ochimus
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA INdex Match generating Error 1004

    What normal do in I & M formula whenever there is no match– you include an error trapping such as iferror. You also need to do the same with VBA if there is no match.
    Ifisnumeric(j) then

    End if

+ 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. Index and Match Run time error 1004
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-20-2018, 08:58 AM
  2. Index Array Match - 1004 Error
    By Nipius in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2016, 10:54 AM
  3. VBA Index/match Error 1004
    By albertli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2015, 09:37 PM
  4. Replies: 10
    Last Post: 05-22-2014, 06:44 AM
  5. [SOLVED] Match & Index code results in Runtime error 1004
    By DJvdW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2013, 03:52 AM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. Generating 1004 error messages while running a marco
    By niceman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 08:20 AM

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