In this Excel VBA Collections video, we see how to read from a worksheet to a VBA Collection and to read from a VBA Collection to a worksheet.
Many people get confused when trying to write out a collection to a worksheet. But it's pretty easy once you know how.
Related links:
The Excel VBA Handbook Course([ Ссылка ])
Webinar Archives - 60+ Hours of VBA training([ Ссылка ])
The Ultimate Guide to Collections in Excel VBA: [ Ссылка ]
Get your free Arrays/Dictionary/Collections cheat sheet here: ([ Ссылка ])
Table of Contents:
01:20 Current Region
02:34 Reading from the worksheet
05:26 Passing a Collection to another Sub
07:31 Writing from a Collection to a worksheet
10:12 Reading the data header to the Collection
Shortcut Keys:
Ctrl + G: View the Immediate 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.
![](https://i.ytimg.com/vi/qzrrcs4164c/maxresdefault.jpg)