+ Reply to Thread
Results 1 to 2 of 2

Runtime error 1004 with Application.Worksheetfunction.Match

  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    Boston, MA
    MS-Off Ver
    365
    Posts
    55

    Runtime error 1004 with Application.Worksheetfunction.Match

    I'm getting this error only sometimes when I run my code. If i just ignore it and run it a couple more times it will eventually work. Is this a known issue?

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Runtime error 1004 with Application.Worksheetfunction.Match

    Something isn't being properly defined in your code. If you post it, we'll take a look. NOTE-Click the # icon on the Tools ribbon to enclose it in CODE tags.

+ 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] runtime error 1004 Getsaveasfilename of object application failed
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2017, 09:57 AM
  2. Urgent: Runtime-error:1004 with application.goto in excel-2010
    By gyani86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2013, 07:43 AM
  3. [SOLVED] Excel VBA Runtime error '1004' "If WorksheetFunction.Find" function
    By miguelitoven in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2013, 04:34 PM
  4. [SOLVED] WorksheetFunction.match run time error '1004' with numbers but not text
    By Hussar13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2013, 05:31 PM
  5. Application.Worksheetfunction.match ERROR
    By Guido Meng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 01:27 PM
  6. worksheetfunction.match giving run time error '1004'
    By devo2511 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2010, 04:47 PM
  7. Runtime error 1004 with use of WorksheetFunction
    By Johny027 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2009, 06:02 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