Search for #VALUE

[Loin75]

Hi - My macro keeps falling over because 1 or 2 cells have hash values.

I want to put some error handling in that will stop the macro running if a hash value is present.

Is it possible to search a specific column for hash values, and even possibly tell the user the location so they could fix the cell(s) themselves?

Many Thanks

 

[Andrew Poulsom]

Example:

Sub Test()
    Dim Cell As Range
    For Each Cell In Range("A1:A10")
        With Cell
            If IsError(.Value) Then
                If .Value = CVErr(xlErrValue) Then
                    MsgBox "Cell " & .Address(False, False) & " contains an error."
                    Exit Sub
                End If
            End If
        End With
    Next Cell
End Sub

 

[Loin75]

Perfect. Thank you.