Skip to main content

Static Arrays

A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution.  The size will be one more than n because VBA array indexes start by default at 0.

You can use an integer variable or constant as the index.

Option Base 1 statement at the start of a module, outside of any procedures. This results in all arrays in the module having a lower bound of 1 instead of 0.

The other choice provides more flexibility, using the To keyword in the array declaration

IDEAScript Language

Robert van den… Fri, 08/31/2018 - 04:34

Is it possible to do this with IDEA script?
'Declare a single-dimension array and set its 4 values. Dim numbers = NewInteger() {1, 2, 4, 8}