Formula works with row. But I need it to work with every col

[mfairbanks]

I set this formula to work if cell BF2 equals No then BG2 through BL2 will fill with "No". Now I need this to work down the whole column. How can I do this?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$BF$2" Then

If LCase(Target.Value) = "no" Then
Range("$BG$2:$BL$2").Value = "No"
End If
End If