Highlight Active Row & Column in Excel
This video is about to highlight active row and column in MS Excel.
=OR(CELL("col")=COLUMN(),CELL("row")=ROW())
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub
#highlight #activeRow #activeColumn #excel