i-nth - VBA: The VBA array

3 October 2015

The VBA array is a very convenient and efficient structure for storing multiple items of usually the same data type. The size of a VBA array can be either fixed or dynamic depending on how it is declared. VBA arrays can also be 1 or multi-dimensional.

This article presents a comprehensive overview of using VBA arrays.

Full article: VBA: The VBA array

Essential reading

Twenty principles for good spreadsheet practice

The twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of errors.

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.