Looping

In this attachment, I'm running a loop for serial numbers but it runs upto 32000 or it creates upto 32000 serial numbers, if I want to create 100K, or 300K then from where the code will be changed.

if you go to how you run the code, choose edit, then the change in the code should be obvious! as well as changing the type to long

Another way:

Please Login or Register  to view this content.

Hi Daveexcel

Thank you very much for your quick reply and solution