Create An Array In VBA

  • Hi,

    I am trying to create an Array, and have searched through many threads on this website and realise I don't have a basic understanding of Arrays. Specifically the ReDim Array function.

    Can someone suggest a good website, that explains how arrays work in VBA?

    Much appreciated

  • Re: Creating An Array In Vba

    Hi Naus

    There's an easy example in the VBA help files when you type:


    Isn't that clear enough, or do you need more help to get it sorted?




    Excel MVP 2011-2014

    For more Excel memes: visit ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: Creating An Array In Vba

    From the VBA help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!