How to Use Arrays Instead of Ranges in Excel VBA
195.4 هزار بار بازدید -
5 سال پیش
-
Learn how to write real-world
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.
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.
5 سال پیش
در تاریخ 1398/08/23 منتشر شده
است.
195,409
بـار بازدید شده