Auto Highlighting the Active Row and Column on Cell Selection – Excel Tips

Auto Highlighting the Active Row and Column on Cell Selection – Excel Tips

Auto Highlighting the Active Row and Column on Cell Selection -Single Line VBA Code

In this video, we will learn about how to highlight the active row and column on cell selection with the help of conditional formatting and single line VBA code. It’s so easy that it will hardly take your 2 minutes.

#AutoHighlight #VBATips

Please download the Excel file from the below link.

https://drive.google.com/file/d/1ZUxuB1BxSl97L8wcziFf3kV7AgGg5wR3/view?usp=sharing

Note: If you are facing issues while copy and pasting then please replace the VBA code ‘Application.calculate’ with

If Application.CutCopyMode=False Then
Application.Calculate
End If

Please visit our website on www.thedatalabs.org

You can contact us on thedatalabs@gmail.com

Thanks for watching!

Please like, share, comment and subscribe.

Have a great day!

Leave a Reply

Close Menu