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
![株式会社CONFRAGE](https://i0.wp.com/confrage.jp/wp-content/uploads/2018/08/aaaaaaaaa-1.jpg?resize=100%2C100&ssl=1)
コメント