Modification Help Needed 649 Combination Generator Code

Hi All

I've been using the following code to generate all the possible 649 combinations. This code will create a sheet containing the combinations, the combinations will be 1,000,000 lines long on Part001, Part002, etc, up to Part014. When I run this after the first couple of parts my computer really starts to slow down until it eventually crawls to the end and all the combinations have been generated.

Is there a way to modify the code that after each part is generated the file is saved and that part is closed? And then the next part can be generated saved and closed and so on until all combinations have been generated, thus helping pervent my computer from slowing down to the speed of a snail? Thanks

Please Login or Register  to view this content.

I'm using Excel 2007. Max rows is 1,048,576

Originally Posted by xladept

And 16,384 columns - that's 17,179,869,184 cells ???

True, never thought of it that way.

So how would I modify the code to have it all on one sheet

I'll give it a try

But, I'd still like to know if it's possible that after each part is generated the file is saved and that part is closed? An how would it be written?

Thanks xladept, I'll give it a try and see if I can make it work.

Will do, thanks again