ExcelBanter - List all combinations

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - List all combinations (https://www.excelbanter.com/excel-programming/437524-list-all-combinations.html)

Bret Bernever

List all combinations

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

All times are GMT +1. The time now is 06:59 PM.