Hi everyone, can anyone help edit this code so that it loops through specific named worksheets "A", "B", "C","D" in my workbook.

Thanks.


Sub ClearERRvalues()
Dim rng As Range
Dim cell As Range
Set rng = Range("A1:z1000")
For Each cell In rng
If cell.Text = "#DIV/0!" Then
cell.ClearContents
ElseIf cell.Text = "#N/A" Then
cell.ClearContents
End If
Next cell
End Sub