Populate 1D vba array from xls spreadsheet

Dear all,
I have lots of data in an excel spreadsheet - say a1:v50000 - and i need it uploaded into a 1D array in VBA.
Then i need all the (i) elements of the VBA array to be the second parameter of a nested function in VBA (x = from 1 to my 1D array (i)), which something i plan to do with an additional nested function with sufficient number of iteration.
But this last piece i think i can handle.
Appreciate your help and hope i made myself clear; not very expert user.
Thank you and regards, n