👉 Ready to master VBA?
- Check out my full courses: [ Ссылка ]
- Subscribe to the channel here: [ Ссылка ]
- Get your free Arrays/Dictionary/Collections cheat sheet here: ([ Ссылка ])
(Note: If the download page doesn't work then make sure to turn off any popup blockers)
In this second video on Excel VBA Collections, I show you how to use both the FOR EACH loop and the standard FOR loop.
Both are useful but one is more flexible and the other is much faster. Check out the results of my speed test to see how much faster.
Table of Contents:
00:42 The FOR EACH Loop
02:45 The Standard For Loop
05:17 Using Step to read specific parts of the collection
05:41 Reading a collection in reverse order
06:38 Speed Test Results: FOR vs FOR EACH
Shortcut Keys
Ctrl + G: View the Immediate Window
F5: Run the code from the current sub
F8: Step through the current sub one line
![](https://i.ytimg.com/vi/NSP8usCrcvs/maxresdefault.jpg)