How to determine if #N/A in VBA

How to determine if #N/A in VBA

How to determine if #N/A in VBA.

You can use IsError to determine this.

Below is an example that is True.

If IsError(Sheets("sheetname").Range("A1")) Then
    ' processing
End If

以下は、#N/A出ない場合の記述方法です。

If IsError(Sheets("sheetname").Range("A1")) = False Then
    ' processing
End If

The above is determined by False, but If Not may also be used.

If Not IsError(Sheets("sheetname").Range("A1")) Then
    ' processing
End If

高橋