Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Create Array using Array() Function


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.


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


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


Function FnArrayFunction()

    Dim arrA As Variant

  Dim strString

  arrA = Array("1", "5", "8", "10")

  For i = LBound(arrA) To UBound(arrA)

      strString = strString & " " & arrA(i) & vbCrLf


  MsgBox strString

End Function
Array Function
Array Function 

Also Read:

  1. VBA-Excel: Date-Time Functions – Date(), Now() and Time()
  2. VBA Excel – Refer to Multiple Ranges : Union Method
  3. VBA-Excel : Strings Functions – Instr
  4. VBA-Excel: Date-Time Functions – FormatDateTime()
  5. VBA-Excel: String Functions – RTrim()