title: cell validation and arrays
body: <p>two questions, first can you remind me how to polulate a multidimensional array when assigning it? I always do it with for loop and how to staticly do it seems to escape me?</p>
  
  <p>But what I am really looking to do is to use the array to validate cells contents. however in the example below I want to use only the first element in the 2nd dimension. </p>
  
  <p>ie<br>
  0,0<br>
  1,0<br>
  2,0<br>
  3,0<br>
  4,0  </p>
  
  <p>Is there any way to update the .Add Type:=xlValidateList, Formula1:=Join(ary, ",") line so it only returns these 5 values from a 5 by 4 array?</p>
  
  <p>Cheeers</p>
  
  <p>aaron</p>
  
  <pre><code>Sub test()
  
  
  Dim ary As Variant
  ReDim ary(5,4)
  
  
  ary = Array("Value1", "Value2", "Value3", "test", "test2", "test3", "test4")
  
  With ActiveSheet.Cells(1, 1).Validation
      .Delete
      .Add Type:=xlValidateList, Formula1:=Join(ary, ",")
      .IgnoreBlank = False
      .InCellDropdown = True
      .InputTitle = ""
      .ErrorTitle = ""
      .InputMessage = ""
      .ErrorMessage = ""
      .ShowInput = True
      .ShowError = True
  End With
  End Sub
  </code></pre>