how to declare constant array in excel vba RRS feed

  • Question

  • Hi All,

    Does it possible to declare const string array like this:

    const MY_TABLE(2) AS String=ARRAY("IN","TW")

    Monday, March 31, 2014 10:13 AM


  • Don't think Array constants are supported by VBA.

    Happy to help ! When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answered

    Monday, March 31, 2014 10:19 AM