Hi.
I've got a macros to fill 4000 rows with unique random numbers from 1 to 30 in B2:AE4001 area.
Every row like this:
14 11 28 20 12 7 30 18 26 13 19 5 6 21 16 25 9 4 8 15 1 27 3 10 24 22 2 23 29 17
I need to fill 162 sheets. The code works good and fast but after a few sheets it gives me the same set as on sheet 1, then as on sheet 2, etc . So I've generated identical sheets as result.
Is it possible to avoid that repetition by modifying the code bellow?
Thanks.
Please Login or Register to view this content.
Bookmarks