Looping through an array

[levo_redkid]

Hi all,
This is probably a very simple baby stuff, but I'm so new at VBA. Still trying to learn...

I'm trying to establish a loop, but that loop will be a list, rather than constantly increasing numbers. In the example below (i = 1 to 100), I would like i to be something like {i = 1,3,8,11,12,20,22,...,100}. Actually I have a quite long list for i. So, how do I make sure that the loop goes through my pre-defined list?

And secondly, my code activates each file twice during the loop, which makes it very slow. Is it possible to make it faster (i.e. without actually activating windows?).

Many thanks..
-levent

Please Login or Register  to view this content.

[omgeokid]

I've been waiting for someone to ask something I think I can actually answer! haha. As far as the looping array, I'm looking into that for a project I'm working on now as well so I can't help there but I think, if you put this code;

Please Login or Register  to view this content.

before you actually start anything else in the code, it stops the windows from updating, making the program a bit faster. If I'm wrong, one of the real guys will let you know, but I'm pretty sure I'm not on this one.

[levo_redkid]

Thanks for that. But I'm still waiting for the core answer.

I found smth like below, maybe it might help you with your case:

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.