Array base

I have been using formulations such as

Please Login or Register  to view this content.

to fill arrays from worksheet ranges
I then find that I will get error message "Subscript out of range") when an array index = 0
However if I then use code like

Please Login or Register  to view this content.

The first column of the range is empty, implying that there is an empty "column" in the array, with a 0 superscript. If this is so then why do I get the error message? It does not seem to make any difference if I specify the option base value at 0 or at 1.
This happens with all workbooks on my machine, usually I just work round it, but I have now a situation where I need a proper solution.
I wonder if the answer lies in the Excel options. I would be grateful for some help
John

The default is option 0,but you can change it to option 1.

When you upload the data in to Array = Range("name").value
what lower and upper bound do you get? This will tell you your boundaries.

I have tried both option bases neither have an effect. AB33, I would like to find out the bounds of the array but I am not sure how to do this can you help?
John

Dim myarray
myarray = Range("name").value
Go to the code itself, go to view -local windows. Run it by pressing F8.If the range is correct and do not get any error, you will see on the windows, something like
myarray(1 to 5, 1 to 6)
the first 1 to 5 is the lower boundary and the second one is the upper boundary

AB3
Thank you for view-local window. I had never got that to work before.
It has revealed the following

Please Login or Register  to view this content.

Shows Array variant() in locals window

Please Login or Register  to view this content.

Shows Array(0 to 415, 0 to 7) in window

Please Login or Register  to view this content.

changes the window to Array(1 to 416, 1 to 8
Why should this be? I am experimenting to see if option base 1 will stop this
John

Norie,
Thanks for clarifying my dimension!
That was my intention, but did not put it the way you did.