Removing #DIV/0! Error from 791 Sheets together

[mhenk]

I have a number of automatically generated sheets. On a number of them, there are #DIV/0! Errors. I would like to replace these #DIV/0! Errors with Blank cells, or, at the very least, change the formatting of these #DIV/0! Errors so that they don't print (i.e. are white)

I have 791 of these sheets, is there any quick method you can suggest to do this?

 

[mhenk]

Here's what I did, kind of a brute force method, but she worked:

Sub Macro3()

For i = 1 To ActiveWorkbook.Sheets.Count
    Sheets(i).Select
    Cells.Select
    Selection.FormatConditions.Delete
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=ISERROR(A1)=TRUE"
    Selection.FormatConditions(1).Font.ColorIndex = 2
    Range("A1").Select
    
    Next i
End Sub

 

[mhenk]

I only have 3.5 GB of RAM here at work... and it's working out well for me so far with this workbook.