Array Processing

[TOMBUGGY]

I have a 2-dimensional array that can have a variable number of rows and columns. Depending on user input it could be 6x6 (36 elements), 6x12 (72 elements), 16x16 (256 elements), etc.

Can someone provide EFFICIENT code for accessing all the elements in row sequence - that is, all the elements in Row 1, then all the elements in Row 2, etc.? Thanks.

 

[AndyGroom]

When you say accessing the elements, do you just mean reading them?

For R& = 1 To UBound(MyArray(1))
  For C& = 1 To UBound(MyArray(2))
    ' Do something with MyArray(R&, C&)
Next C&, R&

- Andy
___________________________________________________________________
If you think nobody cares you're alive, try missing a couple of mortgage payments

 

[TOMBUGGY]

Thanks Andy. To answer your question, I want to "do something" as I access each element.

 

[AndyGroom]

OK well I guess the code I posted should do the trick.

- Andy
___________________________________________________________________
If you think nobody cares you're alive, try missing a couple of mortgage payments

 

[TOMBUGGY]

Andy, not working. The array I'm using is named ddbets and it's dimensioned as ddbets(RR1%, RR2%). I get a Compile Error - Expected Array on the statement:

For R& = 1 to Ubound(ddbets(1))

 

[AndyGroom]

Sorry. Head's a shed.

For R& = 1 To UBound(MyArray, 1)
  For C& = 1 To UBound(MyArray, 2)
    ' Do something with MyArray(R&, C&)
Next C&, R&

- Andy
___________________________________________________________________
If you think nobody cares you're alive, try missing a couple of mortgage payments

 

[TOMBUGGY]

Andy, thanks again. I consulted a manual and found the correct statement content.

 

[AndyGroom]

A programmer who consults the manual? Dying breed.

- Andy
___________________________________________________________________
If you think nobody cares you're alive, try missing a couple of mortgage payments