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


      Next z


      and i get an expected end of statement error


      Please assist me with the correct syntax