vendredi 27 février 2015

Need index for Each Loop with Array

I have an array which I populate with Varibles from an excel table. I then use an each loop to cycle through this array. The allocation of the array lines up with some cell I would like to populate.



'arRow is a Dynamic Array, that varies in size
For each vIndex in arRow
if vIndex = 0 then
'do nothing
else
'Populate corisponding cell
Cells(2, ???).value = vIndex
end if
next vindex


How would I find the index for the Each-Loop?


Aucun commentaire:

Enregistrer un commentaire