For Each "Item" in Array?

[Kelvin Stott]

I was wondering if it is possible to use a For Each-Next construct to cycle through each element of an array, as one does with object collections? In other words, can an array and its elements be treated as objects, or is the only option to use a nested For-Next construct with the appropriate array subscripts?

Thanks for any help.

Kelvin

 

[Rick Rothstein]

I was wondering if it is possible to use a For Each-Next construct to cycle through each element of an array, as one does with object collections? In other words, can an array and its elements be treated as objects, or is the only option to use a nested For-Next construct with the appropriate array subscripts?

What kind of array are we talking about... range? data type? number of dimensions?

 

[Kelvin Stott]

General VBA variant array with multiple but unknown/unspecified number of dimensions.

 

[Rick Rothstein]

General VBA variant array with multiple but unknown/unspecified number of dimensions.

With V declared as Variant, you should be able to do this...

  For Each V In Arr
    Debug.Print V
  Next

It appears to "loop" through the first dimension first, then the second dimension and so on.

 

[Kelvin Stott]

Just what the patient needed, thank you!

 

[shg]

For another perspective, see Using For Each to Loop Through Arrays Is Not Recommended

Learned that from Rory.

 

[Kelvin Stott]

OK, many thanks for this info - very helpful! However I'm working with ParamArrays with variable arrays, so I may have no choice but to use the less efficient For Each-Next approach...

 

[shg]

You always have a choice.