Hello,
hope any of you could help me. I'm a beginner.
I have a UDF + sub to generate some info. It works just fine at one run only - However, I need to execute this script for like 1.000 times in a row.
Problem 1:
--> If I create any kind of loop in this Sub, all information generated by my SUB will be the same - I need a unique value for each run.
I already tried "function Volatile" - didn't work.
It works if I run my module by clicking on a macro button several times, for example. But as I stated, I'd need this automated, as more than 1.000 runs will be needed.
Problem 2:
--> Tried to do the loop out of another Sub, however it gets "out of stack space 28" errors after 50 cycles (I already tried "EnableEvents false", didn't work)
Is there any way I can create a loop after my UDF, then at the end, GOTO to function at the beginning and start all over, till my desired loop count?
Thanks in advance for any kind input.
Bookmarks