Excel VBA Collections: How to use For Loops with Collections (2/5)

preview_player
Показать описание
👉 Ready to master VBA?
(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
Рекомендации по теме
Комментарии
Автор

Great to see you making videos again Paul. Looking forward to the new one. Been wanting to use collections instead of arrays for a while and love the explanation.

krn
visit shbcf.ru