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/power-excel-vba-secret-avoid-using-select/

☕
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.

Видео Excel VBA Range - Avoid Select, You will be glad you did канала Sean Johnson