Results 1 to 3 of 3

Passing an array into multiple Modules

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Passing an array into multiple Modules

    I have 5 arrays (one for Mon - Fri) that I have been re-writing for 3 different modules that are called at 3 different times a day. For example, on Monday Module_1 has the Array written out, Module_2 has the same Array written out, and Module_3 has the same array written out...

    My question is...since it is the same Array being called 3 different times a day, is there a way to declare the Array once, and then call it from Module_1, Module_2, and Module_3? Would cut down on code writing TREMENDOUSLY!!!!


    Actually I thought of one difference in the Arrays.....In Module_1 the workbooks are called like this "Test1.xls" whereas in Module_2 and Module_3 they are only called with "Test"...that may throw a monkey wrench into anything...Idk, but help is appreciated
    Last edited by jo15765; 11-13-2011 at 01:47 AM. Reason: Thought of one difference in the arrays

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