10 Replies Latest reply: Apr 30, 2015 10:30 AM by Robert Mika RSS

    vba to populate an array

    yusuuf rawat

      am trying to populate an array , i can do it manually like this

      sitearray=Array(varsplit(1),varsplit(2) ,varsplit(3),varsplit(4) ...........)

       

      and it works

       

      How do i populate the array using a loop statement

      i tried

      for z=1 to 10

           sitearray=Array(varsplit(z))

      Next z

       

      and i get an expected end of statement error

       

      Please assist me with the correct syntax