-
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
Last edited by Zurigo; 01-27-2012 at 01:11 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules