Results 1 to 3 of 3

Thread: Array (2002 XP)

  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Array (2002 XP)

    Hi all,

    I would like to know, is there a way to keep an array active, like to pass an array to another procedure? The reason I am asking this question is, I have an array that I would like to have access to so that once it is filled I access it when I want, basically keep it in memory, or do I have to fill the array every time I want to use it?

    Thank you in advance.
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Array (2002 XP)

    Declare the array as a public variable at the top of the module, before all Subs and Functions. The array will be available to all code in the workbook during the current session.
    If you want to preserve the values even when the workbook is closed, you should store them somewhere, for example in a text file.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Array (2002 XP)

    Thanks Hans

Posting Permissions

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