i-nth - The ultimate guide to loops in Excel VBA

7 March 2015

Loops are by far the most powerful component of VBA. The aim here is to provide you with an in-depth guide to using loops, written in plain English. The following questions will be addressed:

What are loops?
Why you need them?
When should you use them?
How do they work?
Which one should you in a given situation?

Full article: The ultimate guide to loops in Excel VBA

Connexion
VBA
Excel Macro Mastery
loops

Essential reading

The reification of an incorrect and inappropriate spreadsheet model

Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.