I did a search for "vba powerset" and this was the first hit:

http://www.tushar-mehta.com/excel/tips/powerset.html

--JP

On Oct 26, 11:30*am, Greg Lovern wrote:
Is there a quick way to generate a powerset in Excel?

A powerset is the set of all possible combinations of the items in a
set. For example, given the set a, b, and c, the powerset is:

a
b
c
ab
ac
bc
abc

-- snip --