One-dimensional array in Excel (VBA and VB6) | Free code

Here you can download free code that shows you how a one-dimensional array can be used in VBA code for programming in Excel.

A one-dimensional array is an indexed list that has a base of zero and can be described as consisting of a column and a predetermined number of rows. A one-dimensional array can be created for all data types such as String, Integer, Date and Object. When a one-dimensional array has been created one must determine the size of the single dimension by putting a number inside the parentheses or by assigning a list of data to it.

A one-dimensional array can be used to keep a list of data temporarily in memory. To retrieve a value from a one-dimensional array you must refer to an index position in the list. In this template with free code for a one-dimensional array in Excel, there are two examples that show you how a one-dimensional array can be used. Updated: 01/01/2015 | Created by All-templates.biz

Download One-dimensional array in Excel (VBA and VB6) | Free code »

Tags: excel list collection code