👉 Ready to master VBA?
- Check out my full courses: https://courses.excelmacromastery.com/
- Subscribe to the channel here: https://bit.ly/36hpTCY
- FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: https://bit.ly/2MXsnz9
(Note: If the download page doesn't work then make sure to turn off any popup blockers)
In this Excel VBA video, we look at the differences between the VBA Array and the VBA Collection. Both have very powerful features and are quite different.
It's important to understand them so that you can complete your VBA task more efficiently.
#vbacollection
Table of Contents:
00:20 Comparison 1: Read from a worksheet to a collection
00:47 Reading from a worksheet to a collection
02:08 Reading from a worksheet to an array
04:19 Comparison 2: Reading specific rows from a worksheet
04:53 Reading specific rows to a collection
06:21 Reading selected rows to an array
08:19 Comparison 3: Inserting Items
08:34 Inserting items into a collection
09:17 Inserting items into an array
11:33 Comparison 4: Updating item values
11:48 Updating items in a collection
12:33 Updating items in an array
13:15 Summary of differences between an array and a collection
Related links:
Get your free Arrays/Dictionary/Collections cheat sheet here: (https://bit.ly/2MXsnz9)
The Ultimate Guide to Collections in Excel VBA: (https://excelmacromastery.com/excel-vba-collections)
The Complete Guide to Using Arrays in Excel VBA: (https://excelmacromastery.com/excel-vba-array)
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-vba-webinars/)
Shortcut Keys:
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).