HypRetrieveRange() return error 4 when executed in loop
SummaryHypRetrieveRange() return error 4 when executed in loop
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