Subscript out of range error using all possible combinations code

**alisalamiii** · 05-05-2010, 09:26 AM

I have this code:

Please Login or Register  to view this content.

And it works fine through the first 5 iterations of the i+1 loop, but when it comes to "Next C" I get an error that says subscript out of range. Any ideas why this may be happening?

Any help would be greatly appreciated.
Cheers,
Ali

**MickG** · 05-05-2010, 09:51 AM

Hi, All your named arrays have 5 Elements ,but your loops Have 6.Loops
This array :- Track = Array("a", "b", "c", "d", "e") & similar Have 5 Elements.
Loops:- " For t = 0 To 5" and similar Have 6 loops.
Add an elements to each array or shorten each loop.By 1
Regards Mick