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

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

Or you could look at the .text property:

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


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

--

Dave Peterson

Good point Dave.

Dave Peterson wrote:
> Or you could look at the .text property:
>
> if mycell.text = "#N/A" then
>
>
> 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
>
> --
>
> Dave Peterson