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!