View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
BillCPA BillCPA is offline
external usenet poster
 
Posts: 101
Default Array Dimensioning

Public arrFile() as String

ReDim arrFile(Var0, Var1, Var2, Var3, Var4, Var5, Var6) - variables may be
up to 500

arrFile(Var0, Var1, Var2, Var3, Var4, Var5, Var6) = datastring

--
Bill @ UAMS


"Jim Cone" wrote:

Dim arrBill() as Long
ReDim arrBill(1 to 100, 1 to 7)

The above is a two dimensional array.
What is the structure of your 7 dimensional array?
How are you accessing the elements?
--
Jim Cone
Portland, Oregon USA



"BillCPA" <Bill @ UAMS
wrote in message
Is there a limit on how many dimensions an array can have? VB Help seems to
indicate it is only limited by memory (I have a 4GB machine), and even then
actually has no limit because data is written to and read from disc as needed.

I cannot get an array of larger than four dimensions to work (I want seven).
I have it defined as dynamic. The code will initially ReDim the array
without showing any error. It will allow me to assign values to it. But if
I am monitoring the code and look at the array after a value has been
assigned, it indicates 'subscript out of range', even though the index values
for each dimension are well within the values at the time of the ReDim.

I reduced the number of dimensions down by one from 7, and when I got to
four, it worked.

Any thoughts?

--
Bill @ UAMS