Results 1 to 7 of 7

Thread: EXCEL: How to Initialize a Global Array ??? [Resolved]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved EXCEL: How to Initialize a Global Array ??? [Resolved]

    Esteemed Forum Participants and Lurkers:
    ===============================
    EXCEL VBA

    How do I initialize a global array?

    I can Dim an array before any of my Subs/Functions, but if I do that, there doesn't seem to be any way to initialize the array in the Dim statement.

    I can set: VarName = Array(7, 3, 8, 4)
    but I have to do that in a Sub/Function, and I need to get to the array from several different Subs/Functions. I don't really want to initialize the array every time I call a Sub/Function that uses it. And no, I don't want write a test to see if it is initialized. I just want to create and initialize the array one time.

    Thank you for any and all comments, suggestions, and assistance.
    Last edited by Webtest; May 23rd, 2005 at 12:18 PM. Reason: RESOLVED
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

Posting Permissions

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



Click Here to Expand Forum to Full Width