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.

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.

Please Login or Register  to view this content.