- Set up a variable to hold the Array. This must be a System.Object type variable.

- Set up a variable to hold the current array value. The must be a String.

- Set the array up like this;

Dim sourceTabs() As String

sourceTabs = "Sheet1$,Sheet2$".Split(",")

- Set the loop up using the above variables

- Voila!

(The example above was used to iterate through a fixed list of Excel tabs which were then used as data sources.)

The crucial part was to set up the object as an Array, rather than an ArrayList.

Stu