'If ActiveCell.Value = "#NUM!" Then' error

Hi all

I've got an If function that checks whether the active cell value is less than 9 and if so, sends an email.
Problem is, a good 50 entries will be "#NUM!" when I come to run this macro again which will mean I have to write out around 150 emails.

Is there some way of writing an If that will pick up on the #NUM! error?

Currently have the following:

Please Login or Register  to view this content.

Tried the following:

Please Login or Register  to view this content.

Thanks

#####################################

Fix:

Please Login or Register  to view this content.

You need to use .text instead of .value as the data types for errors will never match.

Try this:

Please Login or Register  to view this content.

Martinez

perhaps this ....

Please Login or Register  to view this content.

.text can have its own problems.