Hello, I'm running into a problem and am wondering if there's an easy way to get around this.
I have three columns of information and I'm trying to get every possible combination. This works when the lists are small, however when I use my actual data - I get an overflow error.
These are the lengths of my list:
Column1 = 6
Column2 = 90
Column3 = 389
This is my code:
Is there any easy way around this?
Please Login or Register to view this content.
I get this error after it generates about 32,767 rows..
Column2 is also dependant on Column1... ie: if Column1 value was A, column2 selection can be reduced to a much smaller amount -- this could potentially help, but I'm unsure of how to code this in - I adapted this code that I'm using from doing some google searching and extensive trial & error.
Thanks for any suggestions.