#Value! Macro error

[M4RSH]

I have excel marco running that transfers information from one page to another. Everything is running fine however i have an issue where some people don't fully fill the sheet in. So this morning with the help of this site (YAY!) I have built in to the Macro that if E3 for example is empty it errors and display a message.

HOWEVER...... In cell H107 I have a calculation that has a running total adding things together and if this is not fully completed I get #VALUE! error which again is fine but again its the small minority that don't fully complete. I want to build a similar IF that if H107 displays #VALUE! it will error and display a message. The code I have written errors when I test it. HELP!!!

If Range("H107").Value = "#VALUE!" Then
MsgBox "Your scoring of this call is incomplete, please recheck ensuring you have completed all the mandatory boxes for this type of call before re-submitting. (This data has not been moved to the Database)"
Exit Sub
End If

VBA highlights the first line and I don't understand why.

[Izandol]

If the cell contains an error value you may not compare that to a string. You may either use the .Text property rather than .Value or use an IsError test:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

[M4RSH]

Cheers, I'll give that ago and report back

[M4RSH]

I used the IsError version and this works. Thank you