+ Reply to Thread
Results 1 to 2 of 2

Find all tabs with formula errors

Hybrid View

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Find all tabs with formula errors

    I'm want to write a macro that searches each tab in my workbook to see if there are any formula errors and if there are to change the tab color so I know to go look at that tab. I'm really not sure where to start.

    Thanks for your help.

  2. #2
    Registered User
    Join Date
    09-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Find all tabs with formula errors

    I managed to figure it out. I only wanted to do it for tabs with names beginning with "#" that's why there is that extra if statement.

     Dim sh As Worksheet
     Dim r As Range
     
    For Each sh In ThisWorkbook.Worksheets
        If Left(sh.Name, 1) = "#" Then
            For Each r In sh.UsedRange
                If IsError(r) Then
                    With sh.Tab
                        .ThemeColor = xlThemeColorAccent4
                        .TintAndShade = 0
                    End With
                End If
            Next
        End If
    Next

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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