Thanks Shaggy.
Yes, the snippet would be the same if i put it in loop 100,000 times, and that's why i think it's useless to repeat it 99,999 more times other than read it just for one time. if only i can put it outside the loop!
And yeah, there shouldn't be an 'and'. (was trying to make my snippet look a bit simpler so that i cut off some part but left the 'and' out)
those RowsCols are actually from an Excel file from which i read data from. there are 27 events listed in a column, and each of them starts when some event finishes. the first event in the column will happen the first, but all the rest will not just happen in the order as they are listed. i need to know the order they start, so that i can calculate the time each event finishes, thus the time all of them finishes(repeat 100000 times). The snippet here is how i determine the order.