Excel VBA Range - Avoid Select, You will be glad you did скачать в хорошем качестве

Excel VBA Range - Avoid Select, You will be glad you did

This tutorial highlights the importance of not using select on a Excel vba range when writing excel macros. Excel VBA book (affiliate) with reviews https://amzn.to/3axlqih You can find out more by viewing the associated blog post for this video at http://www.businessprogrammer.com/pow... ☕ If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson ☕ Using VBA select just emulates user keystrokes which means you are merely writing a macro rather than robust VBA code that results in a bullet business automation process. This tutorial also shows how to use excel VBA currentregion which is a very useful command when manipulating cell ranges. Microsoft Excel acts on spread-sheet ranges by manipulating the Microsoft Office Excel object model. When you avoid using a VBA selection this protects you from having the user create an activecell by clicking somewhere on the spreadsheet that the macro did not anticipate and thus breaking the macro. Excel contains objects to manipulate ranges, spread-sheets and workbooks directly without having to do any type of selection. Video Production =============== Sony Camera: https://amzn.to/3mqyqfu Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum Microphones --------------- Screen Casting: https://amzn.to/3a2TnHN Microphone and Arm : https://amzn.to/3iwvL2S Talking To Camera: https://amzn.to/3FqXI6b Video Kit ------------- Lights Elgato video Lights: https://amzn.to/3sSK3xg Background Light: https://amzn.to/3uTXyPh Note Taking -------------- Rocketbook reusable notebook https://amzn.to/3sSK3xg DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.