Finding row number++

[Niss1]

Hello, once again I ask for help!

On a worksheet event/change I want to see if the value is TRUE on column AK, same/target row and then execute a code.

I have a problem looking up the row number and using it correctly

My code:

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Dim row As Long
    row = Target.row
    If Range("$AK" & row) = True Then
      With Target
            .Offset(1).Resize(5).EntireRow.Hidden = .Value <> "Programmable"
        End With
    End If
    Application.EnableEvents = True
End Sub

Thank you again for any help/input

 

[Niss1]

to avoid any boolean problem i have changed the code a bit, it checks if the value is "YES"

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    'Dim row As Long
    'row = Target.row
    If Range("$AK" & Target.row).Value = "YES" Then
        With Target
            .Offset(1).Resize(5).EntireRow.Hidden = .Value <> "Programmable"
        End With
    End If
    Application.EnableEvents = True
End Sub

unfortunately, it still doesnt work

 

[Norie]

How does it not work?

Is the code actually getting triggered?