Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: "IGNORE ERROR" macro

  1. #1
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    960
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default "IGNORE ERROR" macro

    We do a lot of work with clients who like to have data start with 0, and other stuff.

    Today i have a worksheet with 5 columns of in-cell green triangle error alerts. i like those, but not with certain clients.

    My kingdom for a macro that will "IGNORE ERROR" on the entire sheet at once.

    Possible? thanks

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,115
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    like this ?

    Code:
    Sub Macro1()
        With Application.ErrorCheckingOptions
            .EvaluateToError = True
            .TextDate = True
            .NumberAsText = True
            .InconsistentFormula = True
            .OmittedCells = True
            .UnlockedFormulaCells = True
            .EmptyCellReferences = True
            .ListDataValidation = True
            .InconsistentTableFormula = True
        End With
    End Sub
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    960
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Thank you, but when i run this, nothing happens, literally. I ran it with no cells selected and all cells selected.

    Thoughts?

  4. #4
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,115
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    it should just turn of the error checks, maybe change to false from true
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  5. #5
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    960
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Very Nice . . . . . Thanks.

  6. #6
    MrExcel MVP
    Join Date
    May 2009
    Posts
    14,340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Quote Originally Posted by Jeffrey Green View Post
    We do a lot of work with clients who like to have data start with 0, and other stuff.

    Today i have a worksheet with 5 columns of in-cell green triangle error alerts. i like those, but not with certain clients.

    My kingdom for a macro that will "IGNORE ERROR" on the entire sheet at once.

    Possible? thanks
    Turn off error checking File>Options>Formulas> Error Checking --> uncheck 'Enable background error checking'
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  7. #7
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    960
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Sorry, i spoke to soon . . . . that macro turns off my Error checking options . . . universally. I would like the macro to just "Ignore Errors" as if i was selecting that i the little pull down on the first cell . . . . just for that data range

  8. #8
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,115
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    Maybe JoMo way will do that, I assumed turn it off on one turned off the global option, I don't see errors
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  9. #9
    Board Regular
    Join Date
    Oct 2007
    Location
    Detroit area
    Posts
    960
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: "IGNORE ERROR" macro

    I am doing a work around using JoMo's way. I duplicate the Macro, and changed FALSE to TRUE. I named one macro ERRORSOFF and the other ERRORSON. I run OFF to see what i want to see, and run ON for the next workbook where i want to see errors. Then i put both on my quick access toolbar.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com