{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист2"],"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":"Лист2","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,9,3,19]]}
["ABC",null,"ABCD",3,null,null,"AB","ABC"]
["ABD",null,null,null,null,null,"AC","ABD",null,"Есть 4 элемента (A, B, C, D) . Помогите сгенерировать в VBA все возможные комбинации из них в лексикографическом порядке по выбранному числу? Например если по 2, тогда должно быть 12 комбинаций (4!/(4-2)!=12):"]
["ACB",null,null,null,null,null,"AD","ACB"]
["ACD",null,null,null,null,null,"BA","ACD"]
["ADB",null,null,null,null,null,"BC","ADB",null,"если по 3, тогда должно быть 24 комбинации (4!/(4-3)!=24):"]
["ADC",null,null,null,null,null,"BD","ADC",null,"http://www.excelworld.ru/forum/10-36383-1"]
["BAC",null,null,null,null,null,"CA","BAC"]
["BAD",null,null,null,null,null,"CB","BAD"]
["BCA",null,null,null,null,null,"CD","BCA"]
["BCD",null,null,null,null,null,"DA","BCD"]
["BDA",null,null,null,null,null,"DB","BDA"]
["BDC",null,null,null,null,null,"DC","BDC"]
["CAB",null,null,null,null,null,null,"CAB"]
["CAD",null,null,null,null,null,null,"CAD"]
["CBA",null,null,null,null,null,null,"CBA"]
["CBD",null,null,null,null,null,null,"CBD"]
["CDA",null,null,null,null,null,null,"CDA"]
["CDB",null,null,null,null,null,null,"CDB"]
["DAB",null,null,null,null,null,null,"DAB"]
["DAC",null,null,null,null,null,null,"DAC"]
["DBA",null,null,null,null,null,null,"DBA"]
["DBC",null,null,null,null,null,null,"DBC"]
["DCA",null,null,null,null,null,null,"DCA"]
["DCB",null,null,null,null,null,null,"DCB"]