title: VBA to refresh Bloomberg data not running in proper order
body: <p>my purpose is to update Bloomberg data and do some calculatations with different tickers. But it seems that VBA will run all the calculations without waiting the data to be updated. 
  Here is the code:</p>
  
  <pre><code>Application.Calculation = xlCalculationAutomatic
  
  For i = 1 To 3
  
      Call Worksheets("Sheet1").Range("data1").Select 'the cells "data1" contains the function =BDH(ticker, field, start date, end date) to get the information from Bloomberg'
  
      Call Application.Run("RefreshCurrentSelection")
  
      Worksheets("sheet1").Range("d3").Value = Worksheets("sheet1").Range("sum") 'the cells "sum" takes the sum of all BB info'     
  </code></pre>
  
  <p>Anyone know how to fix it?</p>