Bloomberg calls

How do you handle Bloomberg XLS values that aren't complete?

Sub Something()

    If Application.WorksheetFunction.CountIf(Range(Cells(5, 5), Cells(lastRow, 8)), "#N/A Requesting Data...") > 0 Then
        Application.OnTime Now + TimeValue("00:00:30"), "Something"
        Exit Sub
    End If
    
End Sub

The code as is keeps delaying until all values specified are done loading from Bloomberg.

Source: Bloomberg API best practices