Thanks again, I've got the macro to work. Could we alter the macro so that
the subsets are copied onto the active sheet rather than listed as a message
box? If so do you know the code required?

Thanks

"Gary''s Student" wrote:

You are correct.

For more info on VBA see:

http://www.cpearson.com/excel/codemods.htm

--
Gary''s Student


"Syndrome" wrote:

Thanks for this.
I'm no expert in VBA though. Do I just copy this into a module and run the
macro whilst within the spreadsheet? Or is there anything else I should be
doing?

Thanks again.

"Gary''s Student" wrote:

See Coleman's response in :


http://groups.google.com/group/micro...529de2aaf 685



--
Gary''s Student


"Syndrome" wrote:

I have 15 cells with differing data in them, for example Andy in A1, Lesley
in A2, Keith in A3 etc etc.
I want to calculate and list the different combinations of the entries in a
column..... For e.g Andy
Andy, Lesley
Andy, Keith
Andy, Lesley, Keith
Lesley, Keith