Results 1 to 8 of 8

Handling and storing values on global variables while running several macros

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Question Handling and storing values on global variables while running several macros

    Hello!

    I'm using a workbook that runs 15 macros which create 18 sheets of information based on 1 sheet of raw data. At the moment, the user has to input requested values that are used for the macro that is currently running, but many of these values are repeated and all of them could be entered at the beginning, upon launching the first macro, because they all refer to locations of the data fields from the first sheet of raw data. So I'm thinking that I should stop using local variables and store them for all the macros to use, and clear them only once all of them have run. The question is how do I define global variables and where should I place the code where the values for these are entered?

    Thanks in advance.
    Last edited by Pichingualas; 02-23-2012 at 10:56 AM.

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