Number Generation

Hi Roel,

It worked. Can you make the result at "A1" loop continuously once the count reaches 10 and start allover from number 1 again

Regards
Dilan

Originally Posted by DILANHJ

It worked. Can you make the result at "A1" loop continuously once the count reaches 10 and start allover from number 1 again

If you do that, you will lock Excel up in an endless loop and you will not be able to use it until you have Windows Task Manager kill the process. There should be ways to get around this problem by adding some additional event procedures, but you still will not be able to use Excel while the count is going on. Is that what you really want?

Hi Rick,

Yes, I need a endless loop. the sheet will be used as a dashboard.

I did tried a formula with rand() function "=INT(RAND()*(10-1)+1)". The formula gets updates when the sheet is auto-updated or saved. The problem with the formula is, it returns a random number within the range given. my requirement is to return a incremental number from the range and loop.


Regards
Dilan