List all combinations

B

Bret Bernever

Setup: 5 players, 3 different colored shirts. I want to list all
possible combinations on a worksheet. Something like:

Alfa Bravo CharlieDelta Echo
Red White Blue
Red White Blue
Red White Blue

How can that be accomplished in VBA?
Thanks in advance,
Bret
 
Top