{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Macro Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macro Example","index":0,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Input",null,null,null,"Output",null,null,null,null,"Instructions:"]
[null,"Parm1","Parm2","Parm3","Parm4","Parm1","Parm2","Parm3","Parm4",null,"1. Create a list with a column for each parameter, and using "]
["Possible values","A",1,"X",5,"A",1,"X",5,null,"    the rows for each possible value that the parameter can have"]
[":","B",2,"Y",6,"A",1,"X",6,null,"2. Select the array of possible values, B4:E8 in this case, then run"]
[":","C",null,"Z",7,"A",1,"X",7,null,"    the sub_CrossJoin macro from the Developer tab in the menu"]
[":",null,null,null,8,"A",1,"X",8,null,"3. All the possible combinations will be listed to the right of the input array"]
[null,null,null,null,9,"A",1,"X",9]
[null,null,null,null,null,"A",1,"Y",5,null,"The macro was found here:"]
[null,null,null,null,null,"A",1,"Y",6,null,"http://stackoverflow.com/questions/24788986/modifying-excel-vba-that-creates-all-possible-combinations-from-multiple-lists"]
[null,null,null,null,null,"A",1,"Y",7,null,"with credit to spioter"]
[null,null,null,null,null,"A",1,"Y",8]
[null,null,null,null,null,"A",1,"Y",9]
[null,null,null,null,null,"A",1,"Z",5]
[null,null,null,null,null,"A",1,"Z",6]
[null,null,null,null,null,"A",1,"Z",7]
[null,null,null,null,null,"A",1,"Z",8]
[null,null,null,null,null,"A",1,"Z",9]
[null,null,null,null,null,"A",2,"X",5]
[null,null,null,null,null,"A",2,"X",6]
[null,null,null,null,null,"A",2,"X",7]
[null,null,null,null,null,"A",2,"X",8]
[null,null,null,null,null,"A",2,"X",9]
[null,null,null,null,null,"A",2,"Y",5]
[null,null,null,null,null,"A",2,"Y",6]
[null,null,null,null,null,"A",2,"Y",7]
[null,null,null,null,null,"A",2,"Y",8]
[null,null,null,null,null,"A",2,"Y",9]
[null,null,null,null,null,"A",2,"Z",5]
[null,null,null,null,null,"A",2,"Z",6]
[null,null,null,null,null,"A",2,"Z",7]
[null,null,null,null,null,"A",2,"Z",8]
[null,null,null,null,null,"A",2,"Z",9]
[null,null,null,null,null,"B",1,"X",5]
[null,null,null,null,null,"B",1,"X",6]
[null,null,null,null,null,"B",1,"X",7]
[null,null,null,null,null,"B",1,"X",8]
[null,null,null,null,null,"B",1,"X",9]
[null,null,null,null,null,"B",1,"Y",5]
[null,null,null,null,null,"B",1,"Y",6]
[null,null,null,null,null,"B",1,"Y",7]
[null,null,null,null,null,"B",1,"Y",8]
[null,null,null,null,null,"B",1,"Y",9]
[null,null,null,null,null,"B",1,"Z",5]
[null,null,null,null,null,"B",1,"Z",6]
[null,null,null,null,null,"B",1,"Z",7]
[null,null,null,null,null,"B",1,"Z",8]
[null,null,null,null,null,"B",1,"Z",9]
[null,null,null,null,null,"B",2,"X",5]
[null,null,null,null,null,"B",2,"X",6]
[null,null,null,null,null,"B",2,"X",7]
[null,null,null,null,null,"B",2,"X",8]
[null,null,null,null,null,"B",2,"X",9]
[null,null,null,null,null,"B",2,"Y",5]
[null,null,null,null,null,"B",2,"Y",6]
[null,null,null,null,null,"B",2,"Y",7]
[null,null,null,null,null,"B",2,"Y",8]
[null,null,null,null,null,"B",2,"Y",9]
[null,null,null,null,null,"B",2,"Z",5]
[null,null,null,null,null,"B",2,"Z",6]
[null,null,null,null,null,"B",2,"Z",7]
[null,null,null,null,null,"B",2,"Z",8]
[null,null,null,null,null,"B",2,"Z",9]
[null,null,null,null,null,"C",1,"X",5]
[null,null,null,null,null,"C",1,"X",6]
[null,null,null,null,null,"C",1,"X",7]
[null,null,null,null,null,"C",1,"X",8]
[null,null,null,null,null,"C",1,"X",9]
[null,null,null,null,null,"C",1,"Y",5]
[null,null,null,null,null,"C",1,"Y",6]
[null,null,null,null,null,"C",1,"Y",7]
[null,null,null,null,null,"C",1,"Y",8]
[null,null,null,null,null,"C",1,"Y",9]
[null,null,null,null,null,"C",1,"Z",5]
[null,null,null,null,null,"C",1,"Z",6]
[null,null,null,null,null,"C",1,"Z",7]
[null,null,null,null,null,"C",1,"Z",8]
[null,null,null,null,null,"C",1,"Z",9]
[null,null,null,null,null,"C",2,"X",5]
[null,null,null,null,null,"C",2,"X",6]
[null,null,null,null,null,"C",2,"X",7]
[null,null,null,null,null,"C",2,"X",8]
[null,null,null,null,null,"C",2,"X",9]
[null,null,null,null,null,"C",2,"Y",5]
[null,null,null,null,null,"C",2,"Y",6]
[null,null,null,null,null,"C",2,"Y",7]
[null,null,null,null,null,"C",2,"Y",8]
[null,null,null,null,null,"C",2,"Y",9]
[null,null,null,null,null,"C",2,"Z",5]
[null,null,null,null,null,"C",2,"Z",6]
[null,null,null,null,null,"C",2,"Z",7]
[null,null,null,null,null,"C",2,"Z",8]
[null,null,null,null,null,"C",2,"Z",9]