Handling #N/A in a cell evaluation

[englishkid19]

Hi All,
Im trying to do a simple If statment where i evalautate the content of a cell in a given column, however several cells contain #N/A and i cannot get it to evaluate the error and then place text in the cell .
My code is below ..........


If Cells(n, "BB") Is Err.Num = 2042 Then
Cells(n, "BB") = "ERROR"
Else if

Anyone got any suggestion ( 2042 ) is the number of the error im getting , anything to get the cell with #N/A in to say error would do >>
???
THanks

 

[Andrew Poulsom]

Example:

    With Cells(n, "BB")
        If IsError(.Value) Then
            If .Value = CVErr(xlErrNA) Then
                .Value = "ERROR"
            End If
        End If
    End With