+ Reply to Thread
Results 1 to 4 of 4

Loop Array Iteration and Processing

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Lexington, KY
    MS-Off Ver
    Excel 2003
    Posts
    24

    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.
    Last edited by Bigced_21; 11-01-2010 at 09:34 AM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Loop Array Iteration and Processing

    Maybe something like this, but it still has problems:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    Lexington, KY
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Loop Array Iteration and Processing

    Dear Forum,
    I apologize for not applying the cross posting rule #8 that I was not aware of and I accept that responsibility for not reading.
    I can assure you that will not happen again.
    Thank you for your time and advice.

  4. #4
    Registered User
    Join Date
    08-16-2010
    Location
    Lexington, KY
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Loop Array Iteration and Processing

    Quote Originally Posted by shg View Post
    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.
    Last edited by romperstomper; 11-01-2010 at 11:20 AM. Reason: correct tag

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1