Static Arrays

Primary tabs

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:


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}

Brian Element's picture

That would be nice but you can't do with with IDEAScirpt.  You need to do it one at a time or through a loop.