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: Fill Excel Range Values in a 2D Array