title: Bloomberg Data... Why doesn't Application.WorksheetFunction.BDH work?
body: <p>I am trying to import Bloomberg historical data directly into an array in VBA:</p>
  
  <pre><code>Dim data As Variant
  
  ticker = "UKGRABIQ Index"
  start_date = "12/31/1998"
  end_date = "3/31/2015"
  
  data = Application.WorksheetFunction.BDH(ticker, "PX_LAST", start_date, end_date, "ARRAY=TRUE")
  
  Range("A1", "A66").Value = data
  </code></pre>
  
  <p>The end goal is to be able to do a lot of manipulation on that data, not to just have it appear in the worksheet.</p>
  
  <p>Thanks in advance for the help.</p>