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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks