{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil1","index":0,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["DATES","LIBELLES","BANQUE","CAISSE","cotisations","subventions","dons"]
["2018-04-01","SOLDE PRECEDENT",320.17,25,null,null,null,null,"N1","N2","N3"]
["2018-04-04","Cotisation Ph.MARTIN",80,null,80,null,null,null,{"$f":"SUM(C2:C7)","v":512.2700000000001},{"$f":"SUM(D2:D7)","v":25},{"$f":"SUM(E2:E7)","v":160},null,"Code à mettre dans la Feuil1"]
["2018-04-05","Cotisation Anne BERNARD",80,null,80,null,null,null,456,0.25]
["2018-04-12","Subvention mairie",100,null,null,100,null,null,null,null,null,null,"Nommer la plage I2:K4 à votre convenance"]
["2018-04-14","Achats stylos et papier",-25.6]
["2018-04-28","Paiement fact. Telephone",-42.3]
["1900-01-10"]
["1900-01-11"]
["1900-01-11",null,null,null,null,null,null,null,null,null,null,null,"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"]
["1900-01-12"]
["1900-01-12",null,null,null,null,null,null,null,null,null,null,null,"    Dim ws As Worksheet"]
["1900-01-12",null,null,null,null,null,null,null,null,null,null,null,"    Dim plage As Range"]
["1900-01-12",null,null,null,null,null,null,null,null,null,null,null,"    Dim newPlage As Range"]
["1900-01-14"]
["1900-01-14",null,null,null,null,null,null,null,null,null,null,null,"' Définir les plages"]
["1900-01-14",null,null,null,null,null,null,null,null,null,null,null,"    Set ws = ActiveSheet"]
["1900-01-15",null,null,null,null,null,null,null,null,null,null,null,"    Set plage = ws.Range(\"Plage\")"]
["1900-01-15",null,null,null,null,null,null,null,null,null,null,null,"    "]
["1900-01-15",null,null,null,null,null,null,null,null,null,null,null,"    Set newPlage = ws.Range(\"I\" & ActiveWindow.ScrollRow + 1)"]
["1900-01-16",null,null,null,null,null,null,null,null,null,null,null,"    ' Vérifier si la cellule sélectionnée fait partie de la plage définie"]
["1900-01-15",null,null,null,null,null,null,null,null,null,null,null,"    If Not Intersect(Target, plage) Is Nothing Then"]
["1900-01-16",null,null,null,null,null,null,null,null,null,null,null,"        ' Ne rien faire si la cellule sélectionnée fait partie de la plage définie"]
["1900-01-16",null,null,null,null,null,null,null,null,null,null,null,"        Exit Sub"]
["1900-01-17",null,null,null,null,null,null,null,null,null,null,null,"    End If"]
["1900-01-17",null,null,null,null,null,null,null,null,null,null,null,"    ' Déplacer la plage"]
["1900-01-17",null,null,null,null,null,null,null,null,null,null,null,"    plage.Cut Destination:=newPlage"]
["1900-01-17",null,null,null,null,null,null,null,null,null,null,null,"End Sub"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]
["1900-01-17"]