Remove cell warnings

Posted on 2014-08-15
Last Modified: 2014-08-18

Im getting a "cell unrptected error" after some formatting, can i have a line of code that removes that warning?

Question by:Seamus2626
    LVL 14

    Assisted Solution

    by:Brad Groux
    aCell.Errors(i).Ignore = bIgnore

    Sub IgnoreErrCheckingOnRange(aRange As Range, bIgnore As Boolean)
        '-- This switch off/on all 8 types of error checking on each cell in a specified range.
        Dim aCell As Range, i As Long
        For Each aCell In aRange.Cells
            For i = 1 To 8
               aCell.Errors(i).Ignore = bIgnore
    End Sub
    Sub Test()
        IgnoreErrCheckingOnRange Sheet1.Range("A1:B10"), True
    End Sub

    Open in new window

    LVL 4

    Accepted Solution


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now