Excel - Highlight active cell without VBA

preview_player
Показать описание
The technique demonstrated in this video highlights a cell within a range (without using any VBA code!!!)
Рекомендации по теме
Комментарии
Автор

Thanks alot! Also if you dont want to keep pressing F9, you can add

1) After all the steps.
2) Right click on the sheet (I dont know whats it called) or from the video, Hightlight Selected Cell.
3) Click View Code then select worksheet from the dropdown.
4) It will auto shows:

Private Sub Target As Range)
End Sub

5) Add, Target.Calculate in between.

Private Sub Target As Range)
Target.Calculate
End Sub

6) Close the tab. All done.

I mix this with another yt video and it works for me! Btw Im not IT savvy so idk lol

SuhailaAbdullah-ynje
Автор

you forgot to write the code in the description or in the comment

northwestrepair
Автор

Do you know how to save this trick because if you know then please tell me

imranvibesofficial
visit shbcf.ru