Macro Code - Modify to include > or = to

Hello,

I have the following macro code excel 2010

I am getting a runtime error on the bold/underlin section in the code below.

This code kicks in when M > 14 ... however M can also equal N/A.

Looking to have that part of the coded modified so that if M is > 14 and or equals N/A it shows the pop up as per the macro.

If you need to know N/A is generated based on the following forumula

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance.

Perhaps

Please Login or Register  to view this content.

@JOHN H. DAVIS ... no run time error however the rest of the macro does not work... perhaps I am entering wrong.

@PCI get a runtime error with your option - type mis match error

Thanks for the suggestions rep sent ... anyone else have a suggestion on how to modifiy the macro as per request in post # 1

Can you send a short sample of your data.
Try perhaps

Please Login or Register  to view this content.

two changes

Please Login or Register  to view this content.

and change your formula in column M to this

Please Login or Register  to view this content.

I (and maybe us/we) were under the assumption that the N/A was text, but it's actually the return of NA(), which is the error. I was comparing "N/A" to the error #N/A....

anyways this seem to work....