Array with variable as index?

[LLJ]

I am trying to define an array as the following:

Dim MyArray(x to x+10) as integer

But it seems that VB does not allow me to do so.

I wonder if there is a way to circumvent this so that I can greatly simplify my code using the index number to do something? Otherwise it will be quite tedious.

Thanks

[E. Blackadder]

ReDim will do the trick.

[Brad Gile]

Originally Posted by E. Blackadder

ReDim will do the trick.

Yup. More specifically, start with

Dim MyArray() as Integer

Then after the value of x has been determined, put in the line

ReDim MyArray(x to x+10)

Brad

[Bama Gambler]

LLJ,

I'm not sure why you want to delare an array from x to x+10. If you know you want an array with 11 elements simply declare the array as MyArray(1 to 11). The traditional purpose for ReDim is when you need an array with a variable number of elements.

[Chuck]

Also, if VBA migrates to be consistent with .Net, you will lose the ability to Dim anything other than zero-based arrays. So if you think you'll ever need to convert your code, you're better off just using Dim MyArray(10).

Chuck

[Brad Gile]

Originally Posted by Bama Gambler

LLJ,

I'm not sure why you want to delare an array from x to x+10. If you know you want an array with 11 elements simply declare the array as MyArray(1 to 11). The traditional purpose for ReDim is when you need an array with a variable number of elements.

If you truly want an array that has a variable number of elements at any given point in time, you want to create a Collection.

Brad

[LLJ]

Thanks all-

I cannot say too much about the details. I wanted to do this because I retrive the value of x and manipulate it a lot, if I make it array(1 to 10), I'll have to adjust the index to the X I want all the time.

BTW,it is already working! Thanks

[ACCtuary]

Originally Posted by Bama Gambler

LLJ,

I'm not sure why you want to delare an array from x to x+10. If you know you want an array with 11 elements simply declare the array as MyArray(1 to 11). The traditional purpose for ReDim is when you need an array with a variable number of elements.

Because sometimes it is nice to do the minimal number of mental chores to write up a solution to a problem. The better the syntax lines up with how a programmer thinks, the easier the solution will be (for that programmer).

Let the compiler do the chores, and let people think!

Why does perl provide hashes when the programmer can easily implement them him/herself? Because if you want to write Phone('fred')=15, then by golly why not, and let the language do the hard work of writing the optimal code.

Originally Posted by Chuck

Also, if VBA migrates to be consistent with .Net, you will lose the ability to Dim anything other than zero-based arrays. So if you think you'll ever need to convert your code, you're better off just using Dim MyArray(10).

Chuck

The .NET Common Language Runtime does support non-zero based arrays. Method Array.CreateInstance is used to create them. Various .NET languages may not support non-zero based arrays in syntactically nice ways, though.

[Brad Gile]

Originally Posted by Chevy Chef

The .NET Common Language Runtime does support non-zero based arrays. Method Array.CreateInstance is used to create them. Various .NET languages may not support non-zero based arrays in syntactically nice ways, though.

Indeed. IIRC, support for non-zero based arrays was added during the beta period when some VB developers howled that code with non-zero based arrays would be broken. This from Jeffrey Richter at about the time when Visual Studio.NET was released in 2002:
http://msdn.microsoft.com/msdnmag/issues/02/02/NET/

Originally Posted by Jeffrey Richter

Common Language Specification (CLS) compliance requires that all arrays be zero-based. This allows a method written in C# to create an array and pass the array's reference to code written in another language such as Visual Basic®. In addition, since zero-based arrays are by far the most common, Microsoft has spent a lot of time optimizing their performance. However, the CLR does support non-zero-based arrays but they are discouraged. For those of you who do not care about performance and cross-language portability, I will demonstrate how to create and use non-zero-based arrays later in this section.

Brad