How to avoid .Select, .Activate, Selection скачать в хорошем качестве

How to avoid .Select, .Activate, Selection

In this video we dive into a super important topic for all VBA enthusiasts. Why you should avoid using .Select, .Activate, Selection, and other similar commands in your VBA code. If you’ve ever found yourself frustrated with slow macros or strange bugs, it might be because of these commands. They seem simple, but they can turn your code into a mess—making it harder to read, slower to run, and prone to errors. In this video, I'll show you exactly why these commands should be avoided, and more importantly, how you can replace them with better, more efficient alternatives. So stick around, because this is going to help you take your VBA skills to the next level! ---- 00:00 Intro 00:57 Why to avoid .Select, .Activate, Selection 02:11 Runtime Errors 04:52 Alternatives for .Select, Selection and .Activate 10:44 Alternatives for ActiveCell, ActiveSheet, and ActiveWorkbook 15:10 Outro ---- Software used for recording and editing this video Camtesia: https://techsmith.z6rjha.net/SidRecom... Disclaimer: The above is an affiliate link. At no additional cost to you, we will receive a small commission if you make a purchase using the above links. This helps support the channel. Thank you in advance for your support! Connect with me on social: LinkedIn:   / siddharthrout   Facebook:   / msexcelvba   Instagram:   / altf11ninja   X: https://x.com/AltF11Ninja Stackoverflow: https://stackoverflow.com/users/11405... #ExcelVBA #MSExcel #Excel #ExcelMacro #VBAExcel