To Set the Array ORIGIN
You can set the built-in variable ORIGIN globally or locally to any positive or negative integer.
To Set ORIGIN Globally
On the Calculation tab, in the Worksheet Settings group, select 0 or 1 from the ORIGIN list.
To Set ORIGIN Locally
In the worksheet, you can redefine ORIGIN as follows:
This sets the array index to 5 for all arrays located to the right or below this definition.
Was this helpful?