Be the first user to complete this post

  • 0
Add to List

VBA-Excel: Arrays – Two Dimensional, Static Array

Two dimensional array works like Mxn matrix.

Two Dimensional Array -1
Two Dimensional Array -1

For creating two dimensional static array, follow the below steps

  • Declare an two dimensional Array
  • Store values in array
  • Retrieve values from array.


Declare an two dimensional Array

Dim arrTwoD(1 To 3, 1 To 3)

Store values in array

arrTwoD(2, 3) = 6

Retrieve values from array.

Msgbox        arrTwoD(2, 3)

Complete Code:

Function FnTwoDimensionalArray()

   Dim arrTwoD(1 To 3, 1 To 3)    

   intCounter = 1

   For i = 1 To 3

      For j = 1 To 3

 arrTwoD(i, j) = intCounter

          intCounter = intCounter + 1

      Next

   Next

MsgBox "The Value in 2nd Row and 3rd Column is " & arrTwoD(2, 3)

End Function
Two Dimensional Array -2
Two Dimensional Array -2



Also Read:

  1. VBA-Excel: Date-Time Functions – DatePart()
  2. VBA-Excel : Strings Functions – Right
  3. VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
  4. VBA Excel – Looping Through a Range of Cells
  5. VBA-Excel: CurrentRegion
  6. VBA-Excel: String Functions – LTrim()
  7. VBA-Excel: Arrays – Two Dimension, Dynamic Array
  8. VBA-Excel: Arrays – One Dimension, Dynamic Array