How to create Highlighted Row in Excel

https://www.youtube.com/watch?v=OBRnNui21-E


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Thisworbook.Names("CurrentRow")
    .Name = "currentRow"
    RefersToR1C1 = "=" & ActiveCell.Row
    End With
End Sub

VIDEO Training