+ Reply to Thread
Results 1 to 3 of 3

Application Run Macro not working

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Application Run Macro not working

    I have a Macro that I would like to run one macro after another.
    I have the macro that I execute which has Application.Run ("Macro10") then Application.Run ("Macro11").
    When that finishes, the next sheet is selected and I want the next macro (Macro11) to execute.
    I get the error - run time error 1004 cannot run the macro. The macro may not be available in this workbook or all macros may be disabled.
    What have I done wrong or is it not possible to do this?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Application Run Macro not working

    .
    Not certain why that macro is not running ... but ... I noticed in your post you have the other two macro names in quotation marks (correct method) but Macro11 is not in quotation marks. ???

    Also, check the spelling of your macro name in all locations. Most common error.

  3. #3
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Re: Application Run Macro not working

    Thank you for the advice.
    Just forgot to put in quotation marks, but will check again to see spelling is okay.
    Glad to know that it should work though

+ 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] Working with Application in VBA
    By MarBoTJ in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2018, 09:27 AM
  2. Application Run not working
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2016, 02:53 AM
  3. Application.OnTime Not Working for me
    By treymass in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2013, 02:07 PM
  4. Application.ScreenUpdating not working with Application.Run
    By WaqasTariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 02:24 PM
  5. Excel Macro DO/LOOP not working after cells update from another application
    By rodrigt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2010, 05:26 AM
  6. Macro Not Stopping (Application.Quit not working)
    By Shane O in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2010, 11:59 AM
  7. Application.Run not working
    By Lokutus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 04:25 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