VBA Check Condition Until True Before Moving On?

Is it possible to have excel continually check if a columns used row count in a particular column is greater than a number before moving on to the next part of code?

The reason I'm doing this is because one formula will pull in data from bloomberg which can take some time (5 seconds or so).

Some other code that places formulas into other adjacent columns depends on the number of rows in the first column. So the code following the data pull wil fail if the above hasn't finished pulling yet.

I was thinking about doing something like a do nothing until true?

Here's what I have that is not working:

Do Until Range("A1:A6").Cells.SpecialCells(xlCellTypeConstants).Count > 5 Range("F1").Select
Loop

I expect that the number of used rows in column A should be greater than 5 once data is pulled. In this case I just had VBA select F1 until the count was greater than 5 before moving on. but I think it's interfering with the pull and will coninue to loop..