Very useful and only limited by your imagination
How to Use Arrays Instead of Ranges in Excel VBA
VBA has been part of the Microsoft Office suite for many years. While it does not have the full functionality and power of a full VB application, VBA gives Office users the flexibility to integrate Office products and automate the work you do within them.
One of the most powerful tools available in VBA is the ability to load an entire range of data into a single variable, called an array. By loading data in this way, you can manipulate that range of data in a variety of ways or perform calculations on it.
So what is a VBA array? In this article, we'll answer that question and show you how to use one in your own VBA script.
