title: loop while data refreshes in excel
body: <p>i am trying to create an innocuous loop while bloomberg refreshes a large amount of data. After the data refreshes I want that printed (not an issue).  The problem is, wait and other VBA delay commands actually stop the data from refreshing for some reason.  Seems like an issue w bloomberg.  </p>
  
  <p>I'm looking for a simple Do (something?) loop until a range is all numbers (isnumber).  I just need the program to keep running until all the data is updated so then it can print and move on.  Is there a simple do loop until a range is all numbers I could use?  Thanks</p>