+ Reply to Thread
Results 1 to 8 of 8

How to re run macro after ERROR' Command will stop the debugger'

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    41

    How to re run macro after ERROR' Command will stop the debugger'

    Hi

    I was trying to make some changes to my spreadsheet, and while doing so i think i made a mistake and this error came' The Command will stop the debugger' after that it take me to 'view code' tab with some thing highlighted in yellow .

    Now after that all the fancy macros i added on my spreadsheet stops working

    how do i rerun it again so it takes me back to how the spreadsheet was working until i made an error ?

    Thanks

    Hamza

    Spreadsheet can be provided if needed.

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: How to re run macro after ERROR' Command will stop the debugger'

    use this command on error resume next
    or upload the file.

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: How to re run macro after ERROR' Command will stop the debugger'

    This debugger bit is showing you what went wrong. The reason it stops everything is so that it doesn't destroy all of your work. Please can you put the code on here and let me know what bit is being highlighted yellow. I'll have a look for you.

  4. #4
    Registered User
    Join Date
    09-05-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    41

    Re: How to re run macro after ERROR' Command will stop the debugger'

    Hi

    I will upload the file

  5. #5
    Registered User
    Join Date
    09-05-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    41

    Re: How to re run macro after ERROR' Command will stop the debugger'

    Its not letting me upload

    arghhh!

  6. #6
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: How to re run macro after ERROR' Command will stop the debugger'

    in Go Advances use manage attachement after insert file press done

  7. #7
    Registered User
    Join Date
    09-05-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    41

    Re: How to re run macro after ERROR' Command will stop the debugger'

    Hello

    PLease see attached
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    09-05-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    41

    Re: How to re run macro after ERROR' Command will stop the debugger'

    Quote Originally Posted by Kamboj View Post
    in Go Advances use manage attachement after insert file press done
    I have managed to insert

+ 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] shortcut to stop the debugger without closing VBE?
    By strud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-11-2013, 10:11 AM
  2. [SOLVED] Macro to enable the Stop if true command in Conditional Fomatting
    By qaliq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 04:49 AM
  3. [SOLVED] How to stop error when I cancel the input file source command?
    By XxCMoneyxX in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-15-2013, 03:23 PM
  4. How Do I stop this macro from running if there is an error?
    By jwichern1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2011, 03:13 PM
  5. Script works in Debugger but doesn't when Macro runs
    By sqeekypotato in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-02-2009, 11:31 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