Excel VBA: Highlight the selected row (simple and dynamic code)

In this video, I'm going to show you a VBA code that highlights (in yellow) the entire row of the active cell. Furthermore, this highlighting changes automatically as soon as you select another cell. It's a dynamic feature. Here's the code used: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.EntireRow.Interior.Color = RGB(205, 106, 193) End Sub Feel free to try it out and like the video! Thanks in advance!