Automating My Excel Project

[ArmySanta]

Hi,

I am automating a course schedule. I want to test the above cell. If its value is "n" then to hide the cells below. I am extremely new to VBA and macros. Could someone please tell me what I am doing wrong?

Sub HideRows_Based_On_Values()
If Range("C2").Value = "n" Then
    For Each cell In Range("c3:c20")
        If cell.Value = "n" Then cell.EntireRow.Hidden = True
End If
Next cell
End Sub