Загрузка страницы

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!

Видео Auto Highlighting the Active Row and Column on Cell Selection - Excel Tips канала TheDataLabs
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
8 июня 2019 г. 16:05:09
00:08:52
Яндекс.Метрика