Hi Brette,

use function ISERROR().
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


" wrote:

Hello,

I have a spreadsheet which returns live market prices. From time to
time I receive an error as the price is no available, the error I
receive is #N/A N.A..

I would like to display a warning message to the users that a price is
in error, I would like to check a range of cells for the #N/A N.A.
error, I have over 100 prices.

I hope someone can let me know the best way to do this?

I have tried ISERR and ISNA but it does not work and returns the
result "FALSE".

Thanks in advance,

Brett