Скачать с ютуб How to Use Arrays Instead of Ranges in Excel VBA в хорошем качестве

How to Use Arrays Instead of Ranges in Excel VBA

Learn how to write real-world Excel VBA code: 👉https://courses.excelmacromastery.com/ FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (https://bit.ly/2MXsnz9) Subscribe to the channel here: https://bit.ly/36hpTCY How to Use Arrays Instead of Ranges in Excel VBA Most people don't realise that Arrays are exponentially faster than Ranges in Excel VBA. In this video I cover in detail how to replace ranges with arrays and make your code run faster. Useful VBA Shortcut Keys: View the Immediate Window: Ctrl + G View the Watch Window: Alt + V + H Tab: To move lines of code to the right(Indent). Shift + Tab: To move lines of code to the left(Outdent). Shift + F2: Get the definition of the item under the cursor. Ctrl + Shift + F2: Go to the last cursor position. Ctrl + Space: AutoComplete Word. Alt + F11: Switch between Excel and the VBA Editor. Ctrl + G: view the Immediate Window Ctrl + R: View the Project Explorer Window. Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet. F4: View the Properties Window. F5: Run the code from the current sub. F8: Step into the code. F9(or click left margin): Add a breakpoint to pause the code.