Looping through each element of an array

[Conan Kelly]

Hello All,

Is there better code for looping through each element in an array than

For pintIndex = 0 to 7
'do stuff in pstrArrayName(pintIndex)
Next pintIndex


I was hoping for something like a For...Each statement.

For each (element) in pstrArrayName
'do stuff
Next (element)

Thanks for any help anyone can provide,

Conan Kelly

 

[Trevor Shuttleworth]

Conan Kelly

maybe something like:

For pintIndex = lbound(pstrArrayName) to ubound(pstrArrayName)
'do stuff in pstrArrayName(pintIndex)
Next pintIndex

assuming the number of elements varies (and that's what you are trying to
overcome)

Regards

Trevor

 

[Conan Kelly]

Thanks for the info, Trevor.

 

[unavailable]

As you hoped:

For Each Elem in pstrArrayName
Debug.print Elem
Next

Alan Beban