Macro to Get Results Based on Add-In

[KMVKMVKMV]

Hello,

I am using a macro to help getting results from another application. The results are extracted from the application via an Add-In.

The problem I face is that the results are extracted only after the macro ends. Until the macro is over, the cell containing the Add-In formula (A10 in the example below) is in "Loading" status. This prevents me from getting the correct last row based on the extracted results (will get last row = 10 instead of last row = 22).

My question is - is it possible to make the cell A10 to extract all of the results during the running of the macro, so that I am able to get the correct last number? In other words, can I initiate a "dummy" stop of the my macro instead of breaking the into pieces and call other macros within?

Thanks in advance.

[KMVKMVKMV]

After an additional research, I found the below addition at the end of the loop is what I was looking for.

Please Login or Register  to view this content.

[KMVKMVKMV]

In fact, the question still remains as the above does not work good in case the extraction is heavier and more time is needed.

Does anybody encountered something similar?