{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Sheet1","index":0,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,3,18,4],[12,1,12,2],[20,1,20,2],[20,3,20,4]]}
["処理開始のトリガーのいろいろ"]
[null,null,null,null,null,"データ"]
["処理",null,null,null,null,145]
["黄色の範囲のデータを合計する",null,null,null,null,355]
[null,null,null,null,null,365,null,null,null,null,null,null,null,null,null,"フォームボタン"]
[null,null,null,null,null,111,null,null,null,null,null,null,null,null,null,"標準モジュール"]
[null,null,null,null,null,185]
[null,null,null,null,null,256]
[null,null,null,null,null,85]
[null,null,null,null,null,25]
[null,null,null,null,null,953]
[null,null,null,null,null,478]
[null,"（トリガーの種類）",null,null,null,18,null,null,null,null,null,null,null,null,null,"Activexボタン"]
[null,null,null,null,null,"合計","処理の開始タイミング","コード（数式）の場所",null,null,null,null,null,null,null,"シートモジュール"]
[null,"フォームボタン",null,null,null,2976,"ボタンが押されたとき","標準モジュール"]
[]
[null,"Activexボタン",null,null,null,2976,"ボタンが押されたとき","シートモジュール"]
[]
[null,"Excelの数式",null,"数式",null,{"$f":"SUM(F3:F13)","v":2976},"値が変わったとき","CELL内数式","'=SUM(R[-16]C:R[-6]C)",null,null,null,"セル内の数式"]
[]
[null,"Worksheet_Change",null,"プロシージャ",null,2976,"値が変わったとき","シートモジュール"]
[]
[null,"ActivexCheckBox",null,null,null,2976,"チェックが入ったとき","シートモジュール",null,null,null,null,null,null,null,"Worksheet_Changeプロシージャ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"シートモジュール"]
[]
[]
[]
[null,"excelの関数であるsumをVBA側で利用する場合"]
[null,"「Application.WorksheetFunction」を用います",null,null,null,null,"※WorksheetFunctionは省略可"]
[null,"ans1 =Application.WorksheetFunction.Sum(Range(Cells(3, 6), Cells(13, 6)))"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ActivexCheckBox"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"シートモジュール"]