+ Reply to Thread
Results 1 to 4 of 4

Error 2042 on Application.Match formula

  1. #1
    Forum Contributor
    Join Date
    09-09-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2003
    Posts
    153

    Error 2042 on Application.Match formula

    Can someone help me figure out what is wrong with this? I am getting Error 2042.


    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Error 2042 on Application.Match formula

    See if this helps

    Please Login or Register  to view this content.
    Last edited by mlcb; 01-05-2015 at 12:01 AM.
    Marcelo Branco

  3. #3
    Forum Contributor
    Join Date
    09-09-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2003
    Posts
    153

    Re: Error 2042 on Application.Match formula

    I still get 0 or error 2042.

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Error 2042 on Application.Match formula

    The Straight reason for getting the 2042 error is that the Match Function is not finding the match resulting to #NA (Equivalent to Error 2042).
    Try using
    Please Login or Register  to view this content.
    with Marcelo Branco's Suggestion that is using .Rows(6) instead of Row(6)

    Use F8 to test the code step by step. U can check the return value of Ro and Col by putting ur cursor on these variables.
    and share your results here, if don't get sorted.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

+ 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] Error 2042 using Application.Match to add item and update combobox list
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 07:55 AM
  2. [SOLVED] Application.Match returns Error 2042 whene text absolutely does exist?
    By Rhudi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 04:21 PM
  3. Error 2042 with Application.Match
    By mgurren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 02:15 AM
  4. [SOLVED] Error 2042 with application.vlookup for date
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2013, 03:57 AM
  5. Error 2042
    By magix in forum Excel General
    Replies: 3
    Last Post: 12-12-2005, 08:20 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