{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Сводный","1","2","3","4","5"],"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":"Сводный","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Значение"]
[null,null,"Параметр 1",{"$f":"'1'!$B$2","v":62}]
[null,null,"Параметр 2",{"$f":"'2'!$B$2","v":34}]
[null,null,"Параметр 3",{"$f":"'3'!$B$2","v":12}]
[null,null,"Параметр 4",{"$f":"'4'!$B$2","v":188}]
[null,null,"Параметр 5",{"$f":"'5'!$B$2","v":33}]
[]
["При помощи макроса необходимо собрать на лист Сводный в столбец D значения из листов 1-5, находящихся там в ячейке B2,"]
["сохранив при этом абсолютную ссылку на соотв. Лист."]
["Записал действия макрорекордером. Потом задал все это в цикл. Залил в модуль книги."]
["Не работает((("]
["Где я ошибаюсь? Подскажите, пжл."]

{"sheet":"1","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,62]

{"sheet":"2","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,34]

{"sheet":"3","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,12]

{"sheet":"4","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,188]

{"sheet":"5","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,33]