Hello and welcome to this Excel Macro Mastery video. I’ve been writing code for a long time.
One thing I also try to do when I use a new language or technology is to find the most practical and efficient techniques that I can use.
These techniques are often little-known secrets that only a small percentage of users know.
So in this video, I’m going to show you 5 things that I wish I knew when I started using Excel VBA.
FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (https://bit.ly/2MXsnz9)
Learn how to build 10 full Excel VBA applications from scratch: The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Most what I covered in the video can be found in this article: Excel VBA Copy – The Complete Guide to Copying Data (https://excelmacromastery.com/excel-v…)
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + R: View the Project Properties Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F5: Run the code from the current sub.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent)
Shift + Tab: To move lines of code to the left(Outdent).
Table of Contents:
00:00 – Introduction
00:00 – The Worksheet Codename
02:21 – Current region
04:08 – Copying from Range to Array
06:19 – Using the Split Function
08:57 – The Debug Compile tool