Question about variant arrays

**Atom** · 09-20-2016, 10:16 PM

Please Login or Register  to view this content.

Question:
1. Why does Arr get populated as a 1 d array beginng at zero, while Arr1 is treated as a 2d array beginning at 1?

**millz** · 09-20-2016, 10:26 PM

Can't answer why setting a range begins index at 1, but I guess that's how it is defaulted as. Ranges are always 2D since they have rows and columns.

The array returned from Split function is always 1D.

Split Function

Description

Returns a zero-based, one-dimensional array containing a specified number of substrings.

The beginning index can be controlled by Option Base statement. If you want it to start from 1, do this:

Please Login or Register  to view this content.

Option Base Statement

Used at module level to declare the default lower bound for array subscripts.

Syntax

Option Base {0 | 1}

**jindon** · 09-20-2016, 10:44 PM

Split/Filter function will never be affected by Option Base statement.

It always return 0 based 1 d string array.

However, Array function will be affected.

When you load Range to an array variable, it must be Variant type and always 1 based 2 d array.