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

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

Thanks for the info, Trevor.

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