Break external links after calculation

[Celticfc]

Hi all,

I use VBA to enter array formula linked to external file (cloud).

At the end of my code, I break all links. This results in cells with no values.

This is because Excel needs a bit of time to download the content but because I break links immediately after the code, the values are always nil.

Is there a way, where I can run the break links code once all download JS been done? Once all calculations have been done?

Thank you.

 

[JonXL]

If I'm understanding you correctly:

myRange = myRange.value

This converts you're range into the values in the cells and 'breaks' the links to the external files.