title: Data Manipulation In Excel
body: <p>Fairly easy one I hope. </p>
  
  <p>If I have a column of values in a sheet, How can I set those values to equal a variable I can work with in VBA. </p>
  
  <p>For instance column A has 100 weight values and column b has 100 height values. In a VBA script I want to set "weight" as all values in column A and height as b. and say BMI = weight * height and then write BMI to column C. </p>
  
  <p>I know I can do this example with formulas but for the actual task I'll be looping this a few hundred times and will not know the column index value.</p>
  
  <p>Thanks!</p>
  
  <p>Edit: To specify further, the columns are randomly arranged. I won't be able to use relative cell references. Ultimately I'll be finding the column, naming it working with the data in reference to another column and then finding the next column and doing the same. </p>
  
  <p>Edit 2: I think answers are focusing on achieving the result I specified in the example rather than implementing the process I was trying to describe. </p>