Cycling through 1 dimension of an array

Ok, this I am fairly sure can be done, in fact I was sure I had done it before.

Using index, I know passing 0 as the row or column num returns the entire row or column.

So I have an array containing worksheets, and an associated column number:

Please Login or Register  to view this content.

So now I think I should have a nice array with a list of worksheet 'objects' in the first column, and column numbers in the second column.

So now I want to use a for...each... loop to step through the worksheets, but I don't seem to be able to.

I have this following the code snippet above:

Please Login or Register  to view this content.

Trying to return 'every row of the first column' with rownum=0, and columnnum=1.
However I get the error;

Method 'Index' of object 'WorkSheetFunction' failed

I've then even tried just access the 'column numbers' that I placed in the second column of the array, but I get the same error

Ideas please...

INDEX won't work on an array of objects, I'm afraid.

Ah, that explains that then

I guess it'll be a two array approach then

thanks