Consulting

Results 1 to 1 of 1

Thread: Populate 1D vba array from xls spreadsheet

  1. #1
    VBAX Regular
    Joined
    Jan 2012
    Posts
    6
    Location

    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
  •