Mastering Excel Macros: Arrays
This lesson covers the VBA topics: Arrays, Collections and Dictionaries. Each one of these items help you use macros to manage, calculate and process large amounts of information. Why are these needed? Because performing calculations in macro is exponential faster than performing calculations in a worksheet. Seriously faster. This lesson has a sample workbook where you can test and see the performance improvements. If you are new to my lessons (by lesson 10 you shouldn’t bebut who knows!), you will see a link in the lesson where you can download follow along workbooks so you can practice what you read. I also don’t abandon you after you buy the lesson, if you have any questions, you can email me and I will help you out.