two dimensional Array

VBA-Excel: Fill Excel Range Values in a 2D Array

January 30, 2015October 4, 2013 by Sumit Jain

You can fill a range values from an excel work book into a two dimensional array. All you have to do is assign range values to a variable and then that variable will become array

Function FnFillValues()

VBA-Excel: Arrays – Two Dimension, Dynamic Array

January 30, 2015August 22, 2013 by Sumit Jain

For creating two dimensional dynamic array in excel, follow the steps below:

Declare the two dimensional Array
Resize the array
Store values in array
Retrieve values from array

VBA-Excel: Arrays – Two Dimensional, Static Array

January 30, 2015August 21, 2013 by Sumit Jain

Two dimensional array works like Mxn matrix.

For creating two dimensional static array, follow the below steps

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