5 Things I wish I knew When I started using Excel VBA

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)

Excel VBA Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-vba-webinars/)

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

Shortcut Keys:
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

Видео 5 Things I wish I knew When I started using Excel VBA канала Excel Macro Mastery