Checking if a cell contains an error, and then playing a sound - Cannot check if error

Hello all, I currently have this code:

PHP Code: 

Option Explicit
 
Private Declare Function sndPlaySound32 Lib "winmm.dll" _
Alias "sndPlaySoundA" (ByVal lpszSoundName _
As String, ByVal uFlags As Long) As Long
 
Private Sub Worksheet_Change(ByVal Target As Range)
     
    Dim Cell            As Range
    Dim CheckRange      As Range
    Dim PlaySound       As Boolean
     
    Set CheckRange = Range("C:C")
    For Each Cell In CheckRange
        If Cell.Value = "#N/A" Then
            PlaySound = True
        End If
    Next
    If PlaySound Then
        Call sndPlaySound32("C:\windows\media\chord.wav", 1)
    End If
     
End Sub 


I want it so that if a value in row C is an error ("#N/A") then it plays a sound to the user. I don't know how to adapt this code, any help would be appreciated, thanks.