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
Comments
Robert van den ...
Fri, 08/31/2018 - 04:34
Permalink
Is it possible to do this
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
Fri, 08/31/2018 - 07:15
Permalink
That would be nice but you
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.