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.
rodchar wrote:
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