title: Ms Excel -> 2 columns into a 2 dimensional array
body: <p>Im coming from a Unix world where I never had to develop something for Office with VBA, I have to do some now and Im having a hard time! Please help me! :)</p>
  
  <p>So I've got 2 Excel Sheets(lets call them Sheet1 and Sheet2) and 2 forms(Form1 and Form2) to edit/add data.</p>
  
  <p>In Sheet1, the first two columns are MovieId and MovieName. We dont know how many rows they will be in this columns.
  Form1 controls data in Sheet1, and Form2... in Sheet2.</p>
  
  <p>At Form2 initialization, I want to create a 2 Dimensional Array that will be like (MovieId1,MovieName1;MovieId2,MovieName2;...,...;MovieIdN,MovieNameN), where this data has been extracted from Sheet1, like a sort of Map in Java if you will...</p>
  
  <p>It would actually be ok for me if it was like: (0,"MovieId0;MovieName0";1,"MovieId1,MovieName1";..,"..";N,"MovieIdN,MovieNameN")</p>
  
  <p>I dont know how to create the array with an variable last row number, since the compiler seems to always want a constant to initialize an Array...</p>
  
  <p>Please enlighten me!</p>