HypRetrieveRange() return error 4 when executed in loop

Summary

HypRetrieveRange() return error 4 when executed in loop

Content

Hi everyone,

I have a small macro where I use the function HypRetrieveRange() on a selected range and everything works fine.

But when I use this function in a loop with for example 20 ou 25 ranges to refresh, the function return an error "4" which is basically "we don't know what is happening"

I looked in developer's guide but I don't see any restriction to use this function.

I tried with adding a delay of 10sec before each refresh but this is the same. I put my code below in the snippet

 

Thank you