Mastering Excel Macros: Looping

by Mark Moore

This lesson covers looping. This is how you write a macro that performs actions repeatedly. The lesson covers the various types of loops and it also has a section explaining what collections are and how they relate to looping. Combining the topic of Mastering Excel Macros: IF Statements and this lesson gives you a solid foundation you can use to build more complex macros. Now you can add logic to a macro (covered in Book 4) and repeat that logic as often as needed (this lesson)

As usual, the lesson comes with several follow along workbooks that you can use to work through the exercises at your own pace.
You can download the follow along workbooks by signing up at my website and you will receive an email with the files: http://markmoorebooks.com/macros-loop...

Note these lessons are for Excel for Windows. The screenshots are of Excel 2013 but the code should work for versions of Excel 2007 and forward.

24 pages, Kindle Edition

First published January 16, 2015

About the author

Librarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.

Reviews

[Pascal K Hayes · Rating 5 out of 5]

Great Tutoring Module

Hammers in the fundamentals with step by step code basics. Excellent reading for beginners that have little or no knowledge of how a looping Macro is built.