VBA Code for Highlight Active Row and Column

Published: 13 December 2020
on channel: Aziz360

315

Code for you------------------

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Cells.Interior.ColorIndex = xlNone
Dim a As Integer
Dim B As Integer
a = ActiveCell.Row
B = ActiveCell.Column
ActiveSheet.Rows(a).Interior.ColorIndex = 4
ActiveSheet.Columns(B).Interior.ColorIndex = 9
ActiveSheet.Cells(a, B).Select
End Sub

On this page of the site you can watch the video online VBA Code for Highlight Active Row and Column with a duration of hours minute second in good quality, which was uploaded by the user Aziz360 13 December 2020, share the link with friends and acquaintances, this video has already been watched 315 times on youtube and it was liked by 10 viewers. Enjoy your viewing!

287,056