arrays

[Luis939]

Just to add to my last thread....
How would i run an array with my forloop looking through each worksheet in my workbook, then after performing some instructions, how would i delete an index worksheet from that array if it doesnt meet certain conditions
so when i run a forloop again, it only visits those worksheets that met my condition, not every worksheet in the workbook again..

also, when i run that first for loop and create a variable from the first worksheet that meets my condition, how would
i keep running the forloop and perform a certain instruction if the variables are the same or not
for example, i want to be keep checking to see the value in cell A1 of each worksheets, BUT i want to make sure that there are NO values are the same, if one of the values is the same as one of the previous values, then i do a seperate set of instructions with that value, or else do something, else hope thats clear thanks!!!

 

[Zathras]

Take a look at the Collection object. It sounds like a better fit for what you are trying to do than using an array. See thread707-605398 for a good example of using the Collection object where one might have used an array.

 

[Luis939]

That thread did help a little bit, but i still wouldnt know how to make sure that the values of each worksheet are or arent the same or not? thanks