Looping through each element of an array
 

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

Looping through each element of an array
 

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" <CTBarbarin at msn dot com wrote in message
...
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

Looping through each element of an array
 

Thanks for the info, Trevor.

Looping through each element of an array
 

As you hoped:

For Each Elem in pstrArrayName
Debug.print Elem
Next

Alan Beban

Conan Kelly wrote:
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