I'll try to give more info.
I have a loop, it is set-up only to loop 3 times, each time it manipulates Data to pass to another while loop inside this one. That data that is passed to the second while loop is used to determine what group of Doc's I'll be working with. (loops 20 times)
After it has determined what Group of Doc's I'm working with it loads up the first Doc and enter's a 3rd loop. This For Next loop cycles 300 times. It scans each line in the Doc looking for an indicator (pre-defined marker), when it finds this marker the last loop begins it loops through 7 items seeing if it matches. If it does it echo's the info.
I hope that is kind of clear. While I wrote this I was wondering if I should try to combine the 1st and 2nd loops.
I was wondering If calling a function would be faster then doing a loop and would writing to a file speed things up instead of working with a 700 element array? Or should I create a small For Next loop and remove 400 lines I KNOW are of no use.
The For Next loop at the top I talk about I specified only working with 200 to 500. An array of 700, is it too big?
Thanks for the Help