|Are looking to find the text value ERROR or are you looking to find an Error returned by Excel such as #N/A, #VALUE, #NAME, etc?|
If you are searching for the text value ERROR, change this line in AlteK's fine code from:
If Application.IsError(Range("R" & i)) Then
If UCase(Range("R" & i)) = UCase("Error") Then
The UCase (UpperCase) function is simply to ensure that any version of ERROR (Error, error, ErRoR, etc.) is found.
Note: My suggestion will not find Errors returned by Excel. AlteK's original code does that. Of course, both methods could be used with an OR function so that both types of errors would be found.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.