VBA-Excel: Create Array using Array() Function

Description:

You can create an array using Array() function. You need to provide all the elements which you want in an array inside Array() and store it in a variable and that variable will be converted into array.

Format:

Array(Element1, Element2, Element3…..ElementN)

Arguments:

  • Elements
    • Manda­tory
    • Type: Any Data Type

Read moreVBA-Excel: Create Array using Array() Function