Conditional Timer Using BBG Data in Excel

[a333]

Hello,

I have a loop that continues until the calculation status is done. However, the macro gets stuck and although the calculation is actually done, the macro won't recognize this and proceed to the next step. I want to search every cell in the workbook for #N/A Requesting Data... to try and solve my issue. My code below:

Please Login or Register  to view this content.

Moderators Note: Please follow forum rules and use code tags. Added for you this time, but please use them in the future…Thanks.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

Note: The Private Declare Sub Sleep line must be at the top of the code module.

[a333]

I tried your suggestion above, but this just seems to freeze the calculation process. Ready and calculate both appear in the bottom lefthand corner, but no calculation is in process. I tried breaking and continuing but that did not fix it either. I would like to find a way for the calculation to complete, so I am able to go onto the next steps in the macro.