10 Years of VBA Array Knowledge in 40 Mins скачать в хорошем качестве

10 Years of VBA Array Knowledge in 40 Mins

👉 Ready to Master VBA? Check out my course: https://bit.ly/3XTnIm8 Subscribe to the channel here: https://bit.ly/36hpTCY Want to download the source code for this video? Go here: https://shorturl.at/nMnc6 (Note: If the download page doesn't work then make sure to turn off any popup blockers) "10 Years of VBA Array Knowledge in 40 Mins" Arrays are possibly the most important element of Excel VBA. Not only do arrays make your code more readable, they also allow you to process data thousands of times faster than using Ranges. If you haven't used arrays before then you may be intimidated by them. But don't worry - In this video, I will distil years of VBA knowledge and experience into a set of simple steps that anyone can follow. 💻🔧 #VBAArray #VBAArrays #ExcelVBAArrays Useful VBA Shortcut Keys ======================== Debugging: Compile the code: Alt + D + L OR Alt + D + Enter Run the code from the current sub: F5 Step into the code line by line: F8 Add a breakpoint to pause the code: F9 or click left margin Windows: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H View the Properties Window: F4 Switch between Excel and the VBA Editor: Alt + F11 View the Project Explorer Window: Ctrl + R Writing Code: Search keyword under cursor: Ctrl + F3 Search the word last searched for: F3 Autocomplete word: Ctrl + Space Get the definition of the item under the cursor: Shift + F2 Go to the last cursor position: Ctrl + Shift + F2 Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + * To move lines of code to the right(Indent): Tab To move lines of code to the left(Outdent): Shift + Tab Delete a Line: Ctrl + Y (note: this clears the clipboard) Table of Contents: 00:00 - Introduction 00:22 - Why You Need Arrays 10:17 - How to Replace Ranges with Arrays 21:19 - Using Arrays in a real-world example 27:18 - Important - Avoid this major pitfall 31:59 - The code structure for all data manipulation 40:04 - How to easily sort any Array with this new method