check for #N/A

[Guest]

Hey all,
in VBA how do i check for #N/A? i keep getting a runtime error when code
tries to read this record that has this value.

thanks,
rodchar

 

[JW]

You can use Application.WorksheetFunction.IsNA to search for only #N/A
errors or use VBA's IsError to search for any errors at all.

 

[Dave Peterson]

Or you could look at the .text property:

if mycell.text = "#N/A" then

 

[JW]

Good point Dave.

Or you could look at the .text property:

if mycell.text = "#N/A" then