Loop Array Iteration and Processing

I am a novice at excel vba and array's.
I want to be able to loop thru the wrkshts in the array and pass that wrksht as a variable to my formulas(if i even have those setup correctly) for processing of capturing cell range data for each of the worksheets from month to month basis. I need some serious help getting on track and headed in the right direction. I appreciate your assistance with this. Thanks

Cross Posting Link: http://www.mrexcel.com/forum/showthread.php?t=505417

Please Login or Register  to view this content.

Maybe something like this, but it still has problems:

Please Login or Register  to view this content.

Originally Posted by shg

Maybe something like this, but it still has problems:

Please Login or Register  to view this content.

For the "Else"
I didn't know how to write the range formula when looking in the past month workbook for totals.

Please Login or Register  to view this content.