{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["SOMMAIRE","DIVERS","DECLARATION","CONTROLES","RANGE","TABLEAU 1","TABLEAU 2","Copropriétaire","SUB","SELECTION","TRI","IMPRESSION","INTERNET","HEURES","CARACTERE","PRENOM","Feuil1","Feuil2","Feuil3","Feuil5","Feuil4"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"SOMMAIRE","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LES DÉCLARATIONS"]
[null,"LES CONTROLES"]
[null,"RANGE"]
[null,"TABLEAU 1"]
[null,"TABLEAU 2"]
[null,"SUB"]
[null,"LES SÉLECTIONS"]
[null,"LES TRIS"]
[null,"LES IMPRESSIONS"]
[null,"INTERNET"]
[null,"LES HEURES & DATES"]
[null,"LES CARACTÈRES"]
[null,"DIVERS"]

{"sheet":"DIVERS","index":1,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[]
[null,"LISTER TOUS LES CONTROLES D'UN USERFOM AVEC LEUR PROPRIÉTÉ"]
[null,null,"https://www.excel-downloads.com/threads/vba-objets-dans-userform.154606/"]
[]
[null,"Private Sub UserForm_Initialize()"]
[null,"i = 1"]
[null,"Cells(1, 1) = \"Name\": Cells(1, 2) = \"ControlTipText\": Cells(1, 3) = \"Height\": Cells(1, 4) = \"Left\": Cells(1, 5) = \"TypeName(Ctrl)\": Cells(1, 6) = \"TabIndex\": Cells(1, 7) = \"TabStop\": Cells(1, 8) = \"Tag\": Cells(1, 9) = \"Top\": Cells(1, 10) = \"Visible\": Cells(1, 11) = \"Width\": Cells(1, 12) = \"RowSource\": Cells(1, 13) = \"RowSourceType\": Cells(1, 14) = \"BoundValue\": Cells(1, 15) = \"[_GetID]\": Cells(1, 16) = \"[_GethWnd]\": Cells(1, 17) = \"InSelection\": Cells(1, 18) = \"Parent Name\": Cells(1, 19) = \"Cancel\": Cells(1, 20) = \"ControlSource\": Cells(1, 21) = \"Default\": Cells(1, 22) = \"HelpContextID\": Cells(1, 23) = \"LayoutEffect\": Cells(1, 24) = \"Object\""]
[null,"Cells(1, 25) = \"Parent\": Cells(1, 26) = \"Accelerator\": Cells(1, 27) = \"Caption\": Cells(1, 28) = \"ForeColor\": Cells(i, 29) = \"BackColor\""]
[null,"On Error Resume Next"]
[null,"For Each c In Me.Controls"]
[null,"i = i + 1"]
[null,"With c"]
[null,"Cells(i, 1) = .Name",null,null,"Cells(i, 11) = .Width",null,null,"Cells(i, 21) = .Default"]
[null,"Cells(i, 2) = .ControlTipText",null,null,"Cells(i, 12) = .RowSource",null,null,"Cells(i, 22) = .HelpContextID"]
[null,"Cells(i, 3) = .Height",null,null,"Cells(i, 13) = .RowSourceType",null,null,"Cells(i, 23) = .LayoutEffect"]
[null,"Cells(i, 4) = .Left",null,null,"Cells(i, 14) = .BoundValue",null,null,"Cells(i, 24) = .Object"]
[null,"Cells(i, 5) = TypeName(c)",null,null,"Cells(i, 15) = .[_GetID]",null,null,"Cells(i, 25) = .Parent"]
[null,"Cells(i, 6) = .TabIndex",null,null,"Cells(i, 16) = .[_GethWnd]",null,null,"Cells(i, 26) = .Accelerator"]
[null,"Cells(i, 7) = .TabStop",null,null,"Cells(i, 17) = .InSelection",null,null,"Cells(i, 27) = .Caption"]
[null,"Cells(i, 8) = .Tag",null,null,"Cells(i, 18) = .Parent.Name",null,null,"Cells(i, 28) = .ForeColor"]
[null,"Cells(i, 9) = .Top",null,null,"Cells(i, 19) = .Cancel",null,null,"Cells(i, 29) = .BackColor"]
[null,"Cells(i, 10) = .Visible",null,null,"Cells(i, 20) = .ControlSource"]
[]
[null,"End With"]
[null,"Next c"]
[null,"End Sub"]
[]
[null,"Code un peu plus court….enfin si on veut"]
[null,"Private Sub UserForm_Initialize()"]
[null,"Dim i As Long, j As Long"]
[null,"i = 1"]
[null,"Cells(1, 1) = \"Name\": Cells(1, 2) = \"ControlTipText\": Cells(1, 3) = \"Height\": Cells(1, 4) = \"Left\": Cells(1, 5) = \"TypeName(Ctrl)\": Cells(1, 6) = \"TabIndex\": Cells(1, 7) = \"TabStop\": Cells(1, 8) = \"Tag\": Cells(1, 9) = \"Top\": Cells(1, 10) = \"Visible\": Cells(1, 11) = \"Width\": Cells(1, 12) = \"RowSource\": Cells(1, 13) = \"RowSourceType\": Cells(1, 14) = \"BoundValue\": Cells(1, 15) = \"[_GetID]\": Cells(1, 16) = \"[_GethWnd]\": Cells(1, 17) = \"InSelection\": Cells(1, 18) = \"Parent Name\": Cells(1, 19) = \"Cancel\": Cells(1, 20) = \"ControlSource\": Cells(1, 21) = \"Default\": Cells(1, 22) = \"HelpContextID\": Cells(1, 23) = \"LayoutEffect\": Cells(1, 24) = \"Object\""]
[null,"Cells(1, 25) = \"Parent\": Cells(1, 26) = \"Accelerator\": Cells(1, 27) = \"Caption\": Cells(1, 28) = \"ForeColor\": Cells(i, 29) = \"BackColor\""]
[null,"On Error Resume Next"]
[null,"For Each c In Me.Controls"]
[null,"i = i + 1"]
[null,"With c"]
[null,"For j = 1 To 29"]
[null,"Cells(i, j) = CallByName(c, Cells(1, j), VbGet)"]
[null,"Next j"]
[null,"End With"]
[null,"Next c"]
[null,"End Sub"]
[]
[null,"Et plus court…. Si on veut que ce soit sur 1 ligne"]
[null,"Range(Cells(1, 1), Cells(1, 29)) = Array(\"Name\", \"ControlTipText\", \"Height\", \"Left\", \"TypeName(Ctrl)\", \"TabIndex\", \"TabStop\", \"Tag\", \"Top\", \"Visible\", \"Width\", \"RowSource\", \"RowSourceType\", \"BoundValue\", \"[_GetID]\", \"[_GethWnd]\", \"InSelection\", \"Parent Name\", \"Cancel\", \"ControlSource\", \"Default\", \"HelpContextID\", \"LayoutEffect\", \"Object\", \"Parent\", \"Accelerator\", \"Caption\", \"ForeColor\", \"BackColor\")"]
[]
["COPIER - COLLER"]
[null,"Copier le contenu Feuil3 Range(\"A1:R24\") et le coller dans Feuil4 Range(\"A1\")"]
[null,null,"Private Sub CommandButton3_Click()","dans Feuil4","Range(\"A1\")"]
[null,null,"Worksheets(\"Feuil3\").Range(\"A1:R24\").Copy Destination:=Worksheets(\"Feuil4\").Range(\"A1\")"]
[null,null,"End Sub"]
[]
[null,"Copie la plage A1:D4 de la Feuil1 Sur la Feuil2 à partir de la cellule E4"]
[null,null,"Private Sub CommandButton2_Click()"]
[null,null,"Worksheets(\"Feuil1\").Range(\"A1:D4\").Copy Destination:=Worksheets(\"Feuil2\").Range(\"E5\")"]
[null,null,"End Sub"]
[]
[null,"A TESTER"]
[null,"Worksheets(Nomdelafeuillesource).Range(Plagesource).Copy"]
[null,"Worksheets(Nomdelafeuilledestination).Range(ActiveCell).PasteSpecial"]

{"sheet":"DECLARATION","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,"Pour que la variable soit utilisable dans toutes macros du module, celle-ci doit être déclarée en tête du module, avant le premier Sub.","Pour que la variable soit utilisable dans toutes les macros du projet, il faut utiliser l'instruction Public et la variable doit impérativement être placée en tête d'un module standard."]
[null,"Dim X As String","Option Explicit"]
[null,"Sub Test()","Public X As String"]
[null,"…","Sub Test()"]
[null,"End Sub","..."]
[null,null,"End Sub"]
[]
[null,"EXEMPLES"]
[null,"Module 1","Général…Déclarations Variables"]
[null,"Général…Déclarations","Private Const PremièreCelluleEDD = \"A13\""]
[null,"Public TAB_EDD() As Variant","Private Const NbLignesEDD = 72"]
[null,null,"Private Const NbcolonnesEDD = 19"]
[null,null,"Private Const NbLignesNOM = 24"]

{"sheet":"CONTROLES","index":3,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,"Oui","Beaucoup d'exemples avec le site ci-dessous"]
[null,"Non","https://silkyroad.developpez.com/VBA/ControlesUserForm/#LII-E"]
[null,"Oui"]
[null,null,"Rester dans le TextBox1 en cas d'erreur"]
[null,null,"L'exemple est dans l'Userform1"]
[null,null,"Il faut saisir dans le TextBox1 une valeur inférieur à 5 pour passer dans le TextBox2"]
[]
[]
[null,"Bouton de Commande","Plusieurs lignes dans le Bouton"]
[null,null,"CommandButton1.Caption = \"Ligne1\" & vbCrLf & \"Ligne2\"& vbCrLf & \"Ligne3\""]
[]
[]
[]
[]
[]
[null,"Boutons d'Option"]
[null,null,"Les Frames sont souvent utilisés pour gérer les groupes d'OptionButton."]
[null,null,"Mettre un Frame dans l'Userform puis mettre les Bouton      dans le Frame"]
[]
[null,null,null,"Private Function ligne()"]
[null,null,null,"'La fonction renvoie comme valeur le texte du bouton choisi (ligne)"]
[null,null,null,"    For Each bouton_ligne In Frame_ligne.Controls"]
[null,null,null,"        If bouton_ligne.Value Then"]
[null,null,null,"            ligne = bouton_ligne.Caption"]
[null,null,null,"        End If"]
[null,null,null,"    Next"]
[null,null,null,"End Function"]
[]
[null,"Cases à Cocher","Cliquer sur le buton pour voir l'exemple"]
[]
[]
[]
[null,"ComboBox"]
[null,null,"ATTENTION ","Le premier item d'un ComboBox commence à Zéro"]
[null,null,null,"Si je clique sur le 3ème item"]
[null,null,null,"MsgBox MA_LISTE.ListIndex",null,null,"Affichera 2"]
[]
[null,null,"Pour l'exemple ci-dessous"]
[null,null,null,"Il faut au prélable sélectionner la zone dans la feuille et lui donner un nom"]
[null,null,null,"Sélectionner la zone…Ruban Formules…Définir un noms"]
[null,null,null,null,"    'Remplir LISTE_COPRO"]
[null,null,null,null,"    With Userform1.ComboBox1"]
[null,null,null,null,"        .ColumnCount = 2"]
[null,null,null,null,"        .List = Range(\"LISTE_PRENOM\").Value"]
[null,null,null,null,"        .ColumnWidths = \"0;50\"",null,null,null,"0 pour ne pas voir la 1ère colonne dans le ComboBox"]
[null,null,null,null,"    End With",null,null,null,"50 c'est la largeur de la colonne du ComboBox"]

{"sheet":"RANGE","index":4,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,"L'objet RANGE pour sélectionner une plage",null,null,null,null,null,"Pour un objet RANGE il faut écrire : Set Range ="]
[]
[null,"Plusieurs solutions pour remplir un Tableau à partir d'une feuille",null,null,null,null,null,null,null,"http://codevba.com/fr/Excel/Range.htm#.YN13Ykw6_IU"]
[null,"https://www.excel-pratique.com/fr/vba/tableaux_vba",null,null,null,null,null,null,null,"https://forums.commentcamarche.net/forum/affich-32392214-range-en-vb-excel-c-est-quoi-exactement"]
[]
[null,"ATTENTION - Un tableau commence toujours à la ligne Zéro et la Colonne Zéro"]
[null,null,"Dim tableau(10, 2)",null,"c'est un tableau de 11 lignes et 3 colonnes"]
[]
[null,"Pour l'exemple ci-dessous"]
[null,null,"Selection de la plage A1:B6 de la feuille PRENOM",null,null,null,null,"le bouton ci-dessous change la plge A1:B6"]
[null,null,"Onglet Formules - Sélectionner Définir un nom",null,null,null,null,"Taille police, Couleur, largeur automatique de colonne etc.."]
[null,null,"J'ai donné le nom : LISTE_PRENOM"]
[]
[]
[]
[null,"Sélection avec l'objet Range"]
[null,"Exemple :","Je veux sélectionner la plage  A1 à B6 de la feuille PRENOM"]
[null,null,"Sub SELECTION()"]
[null,null,"    Dim MA_ZONE As Range"]
[null,null,null,null,null,null,null,"Cliquer sur le bouton VOIR"]
[null,null,"    Dim DEBUT_LIGNE As Byte",null,null,null,null,"Aller sur la feuille PRENOM"]
[null,null,"    Dim DEBUT_COLONNE As Byte",null,null,null,null,"La plage A1:B6 est bien sélectionnée"]
[null,null,"    Dim FIN_LIGNE As Byte"]
[null,null,"    Dim FIN_COLONNE As Byte"]
[null,null,"    "]
[null,null,"    Sheets(\"PRENOM\").Activate"]
[null,null,"    DEBUT_LIGNE = 1"]
[null,null,"    DEBUT_COLONNE = 1"]
[null,null,"    FIN_LIGNE = 6"]
[null,null,"    FIN_COLONNE = 2"]
[]
[null,null,"    Set MA_ZONE = Range(Cells(DEBUT_LIGNE, DEBUT_COLONNE), Cells(FIN_LIGNE, FIN_COLONNE))"]
[]
[null,null,"    MA_ZONE.Select"]
[]
[null,null,"End Sub"]
[]
[null,"Sub SelectionNomPlage()"]
[null,null,"Sheets(\"PRENOM\").Activate"]
[null,null,"Range(\"LISTE_PRENOM\").Select"]
[null,"End Sub"]

{"sheet":"TABLEAU 1","index":5,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,null,"LES TABLEAUX 1"]
[null,null,null,null,null,null,null,null,null,"Tablo = Sheets(1).Range(\"A1:A20\").Value"]
[null,"Plusieurs solutions pour remplir un Tableau à partir d'une feuille"]
[null,"https://www.excel-pratique.com/fr/vba/tableaux_vba"]
[]
[null,"ATTENTION - Un tableau commence toujours à la ligne Zéro et la Colonne Zéro"]
[null,null,"Dim tableau(10, 2)",null,"c'est un tableau de 11 lignes et 3 colonnes"]
[]
[]
[]
[null,"Déclaration de l'objet Range",null,null,"Dim MA_ZONE as Range"]
[null,"Exemple :","Je veux sélectionner la plage  A1 à B6 de la feuille PRENOM"]
[null,null,"je vais utiliser des variables ",null,null,"DEBUT_LIGNE avec la valeur 1",null,null,"DEBUT_COLONNE avec la valeur 1"]
[null,null,null,null,null,"FIN_LIGNE avec la valeur 6",null,null,"FIN_COLONNE avec la valeur 2"]
[null,"Soit : ","Set MA_ZONE =","Range(Cells(DEBUT_LIGNE,DEBUT_COLONNE),Cells(FIN_LIGNE,FIN_COLONNE))"]
[null,"Puis","MA_ZONE.Select"]
[]
[]
[]
[]
[null,"Remplir un tableau avec une plage nommée"]
[]
[null,"Avec une boucle",null,null,null,null,"Sans boucle avec Range",null,null,"ATTENTION","le premier numéro n'est pas 0 mais 1"]
[null,"'Déclarations",null,null,null,null,"'Déclaration"]
[null,"Dim tableau(10, 2) 'Tableau de 11 x 3 \"cases\"",null,null,null,null,"Dim tableau()"]
[null,"Dim i As Integer"]
[]
[null,"'Enregistrement des valeurs dans le tableau",null,null,null,null,"'Enregistrement des valeurs dans le tableau"]
[null,"For i = 0 To 10",null,null,null,null,"tableau = Range(\"A2:C12\")"]
[null,"    tableau(i, 0) = Range(\"A\" & i + 2)"]
[null,"    tableau(i, 1) = Range(\"B\" & i + 2)"]
[null,"    tableau(i, 2) = Range(\"C\" & i + 2)"]
[null,"Next"]
[]
[]
[null,"UBound",null,null,null,null,null,null,"Lbound"]
[null,"Renvoie l'indice le plus élevé disponible",null,null,null,null,null,null,"Renvoie le plus petit indice disponible"]
[null,"Sub exemple()",null,null,null,null,null,null,"Sub exemple()"]
[null,"    Dim tableau(10, 4)",null,null,null,null,null,null,"    Dim tableau(10, 4)"]
[null,"    'Indice maximal de la première dimension",null,null,null,null,null,null,"    'Indice minimal de la première dimension"]
[null,"    MsgBox UBound(tableau) 'Renvoie : 10",null,null,null,null,null,null,"    MsgBox LBound(tableau) 'Renvoie : 10"]
[null,"    'Indice maximal de la seconde dimension",null,null,null,null,null,null,"    'Indice minimal de la seconde dimension"]
[null,"    MsgBox UBound(tableau, 2) 'Renvoie : 4",null,null,null,null,null,null,"    MsgBox LBound(tableau, 2) 'Renvoie : 4"]
[null,"End Sub",null,null,null,null,null,null,"End Sub"]
[]
[null,"Exemple avec mon tableau de la feuille PRENOM (6 lignes et 2 Colonnes)"]
[]
[]
[]
[]
[]
[null,"L'exemple suivant montre comment faire référence à la plage nommée « MyRange » dans le classeur nommé « MyBook.xls »."]
[null,"Sub FormatRange() "]
[null,"    Range(\"MyBook.xls!MyRange\").Font.Italic = True "]
[null,"End Sub"]
[]
[null,"Range(\"MaPlage\").select"]
[]
[null,"En précisant la plage  A1:B6"]
[null,"  'Déclaration du Tableau"]
[null,null,"Dim MON_TABLEAU As Variant"]
[null,"  'Stockage de la plage de cellules dans la variable tableau"]
[null,null,"MON_TABLEAU = ActiveWorkbook.Sheets((\"PRENOM\")).Range(\"A1:B6\").Value"]
[null,"A partir de la feuille PRENOM et des cellules nommée LISTE_PRENOM  "]
[null,"  'Déclaration du Tableau"]
[null,null,"Dim MON_TABLEAU As Variant"]
[null,"  'Stockage de la plage de cellules dans la variable tableau"]
[null,null,"MON_TABLEAU = ActiveWorkbook.Sheets((\"PRENOM\")).Range(\"LISTE_PRENOM\").Value"]
[]
[]
[null,"Sélectionner  Ligne - Colonne d'un Tableau",null,null,null,null,null,"ATTENTION","avec Range le premier numéro n'est pas 0 mais 1"]
[null,null,"Exemple"]
[null,null,"'Déclarations",null,null,null,null,"'Déclaration"]
[null,null,"Dim tableau(10, 2) 'Tableau de 11 x 3 \"cases\"",null,null,null,null,"Dim tableau()"]
[null,null,null,null,null,null,null,"'Enregistrement des valeurs dans le tableau"]
[null,null,null,null,null,null,null,"tableau = Range(\"A1:C11\")"]
[null,null," 'Sélections",null,null,null,null," 'Sélections"]
[null,null,"MsgBox tableau(0, 0) ",null,"Ligne 1","Colonne 1","=","MsgBox tableau(1, 1) "]
[null,null,"MsgBox tableau(0, 1) ",null,"Ligne 1","Colonne 2","=","MsgBox tableau(1, 2) "]
[null,null,"MsgBox tableau(9, 2) ",null,"Ligne 10","Colonne 3","=","MsgBox tableau(10, 3) "]
[null,null,"MsgBox tableau(10, 2) ",null,"Ligne 11","Colonne 3","=","MsgBox tableau(11, 3) "]
[]
[null,null,"Déclarer et Sélectionner le Tableau"]
[null,null,"Private Sub CommandButton4_Click()"]
[null,null,"    Dim tableau As Range"]
[null,null,"    Set tableau = Sheets(\"PRENOM\").Range(\"A1:B6\")"]
[null,null,"    Sheets(\"PRENOM\").Activate"]
[null,null,"    tableau.Select"]
[null,null,"End Sub"]

{"sheet":"TABLEAU 2","index":6,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE",null,null,null,null,null,null,null,"1°  ","Option Explicit",null,"A placer dans un Module"]
[null,null,null,null,null,null,null,null,null,"'Constantes paramètres"]
[null,null,null,null,null,null,null,null,null,"Public Const NbLignesNOM = 24"]
[null,null,null,null,null,null,null,null,null,"Public Const PremièreCelluleEDD = \"A8\""]
[null,null,null,null,null,null,null,null,null,"Public Const NbLignesEDD = 24"]
[null,null,null,null,null,null,null,null,null,"Public Const NbcolonnesEDD = 18"]
[null,null,null,null,null,null,null,null,null,"'Variables globales"]
[null,null,null,null,null,null,null,null,null,"Public MON_TABLEAU() As Variant"]
[null,null,null,null,null,null,null,null,null,"Public MA_PLAGE As Range"]
[null,null,null,null,null,null,null,null,null,"Public Exercice As String"]
[null,null,null,null,null,null,null,null,null,"Public SEMAINE As Variant"]
[]
[]
[null,null,null,null,null,null,null,null,"2°  ","Private Sub Workbook_Activate()"]
[null,null,null,null,null,null,null,null,null,"    'Remplissage de MON_TABLEAU à partir de la feuille Copropriétaire"]
[null,null,null,null,null,null,null,null,null,"    MON_TABLEAU = Sheets(\"Copropriétaire\").Range(PremièreCelluleEDD).Resize(NbLignesEDD, NbcolonnesEDD).Value"]
[null,null,null,null,null,null,null,null,null,"    SEMAINE = Array(\"Lundi\", \"Mardi\", \"Mercredi\", \"Jeudi\", \"Vendredi\", \"Samedi\", \"Dimanche\")"]
[null,null,null,null,null,null,null,null,null,"    Worksheets(\"SOMMAIRE\").Select"]
[null,null,null,null,null,null,null,null,null,"End Sub"]
[]
[null,null,null,null,null,null,null,null,"3°  ","Private Sub CommandButton1_Click()"]
[null,null,null,null,null,null,null,null,null," 'Pour Controle"]
[null,null,null,null,null,null,null,null,null,"    'Indice maximal de la première dimension"]
[null,null,null,null,null,null,null,null,null,"    MsgBox UBound(MON_TABLEAU, 1)"]
[null,null,null,null,null,null,null,null,null,"    'Indice maximal de la seconde dimension"]
[null,null,null,null,null,null,null,null,null,"    MsgBox UBound(MON_TABLEAU, 2)"]
[null,null,null,null,null,null,null,null,null," 'Affichage du Copropriétaire Origine - Actuel et Millièmes"]
[null,null,null,null,null,null,null,null,null,"    Sheets(\"TABLEAU 2\").Cells(4, 4) = MON_TABLEAU(4, 2)"]
[null,null,null,null,null,null,null,null,null,"    Sheets(\"TABLEAU 2\").Cells(4, 6) = MON_TABLEAU(4, 3)"]
[null,null,null,null,null,null,null,null,null,"    Sheets(\"TABLEAU 2\").Cells(4, 8) = MON_TABLEAU(4, 18)"]
[null,null,null,null,null,null,null,null,null,"End Sub"]
[]
[null,null,null,null,null,null,null,null,"4°  "," 'Affichage du jour de la semaine "]
[null,null,null,null,null,null,null,null,null,"Private Sub CommandButton4_Click()"]
[null,null,null,null,null,null,null,null,null,"    Sheets(\"TABLEAU 2\").Cells(15, 2) = SEMAINE(0)"]
[null,null,null,null,null,null,null,null,null,"End Sub"]
[]
[null,null,null,null,null,null,null,null,"5°  ","'Suppresion du Contenu de Feuil3"]
[null,null,null,null,null,null,null,null,null,"    Worksheets(\"Feuil3\").Range(\"A2:R25\").ClearContents"]
[]
[null,null,null,null,null,null,null,null,"6°  ","'Copie de MON_TABLEAU dans Feuil3"]
[null,null,null,null,null,null,null,null,null,"    Application.EnableEvents = False"]
[null,null,null,null,null,null,null,null,null,"        With Worksheets(\"Feuil3\")"]
[null,null,null,null,null,null,null,null,null,"        Sheets(\"Feuil3\").Range(\"A2\").Resize(UBound(MON_TABLEAU, 1), UBound(MON_TABLEAU, 2)) = MON_TABLEAU"]
[null,null,null,null,null,null,null,null,null,"        End With"]
[null,null,null,null,null,null,null,null,null,"    Application.EnableEvents = True"]
[null,null,null,null,null,null,null,null,null,"    Worksheets(\"Feuil3\").Select"]
[null,null,null,null,null,null,null,null,null,"End Sub"]

{"sheet":"Copropriétaire","index":7,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,16],[2,0,2,16],[3,0,3,16],[5,0,6,0],[5,1,5,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,8,6,8],[5,9,6,9],[5,17,6,17],[32,0,32,16],[5,10,6,11],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[5,16,6,16]]}
["Retour"]
["RESIDENCE  LES GAIS LURONS"]
["Avenue de l'Opéra"]
["75000 PARIS"]
[]
["N°\nClient","Copropriétaire",null,"Locataire","Résident","Adresse",null,null,"Bât.","Esc.","Etage",null,"Type","Appart","Cave","Garage","Parking","Millièmes"]
[null,"Origine","Aujourd'hui"]
[12,"S.I.B","LE CORRE Sophie",null,{"$f":"IF(D8=\"\",\"Oui\",\"Non\")","v":"Oui"},"Avenue de l'Opéra","PARIS ",75000,"A","A",0,"droite","F3",2,10,null,72,383]
[16,"LENOIR","LOISEL Carole Lénaïc",null,{"$f":"IF(D9=\"\",\"Oui\",\"Non\")","v":"Oui"},"Avenue de l'Opéra","PARIS ",35520,"A","A",0,"gauche","F4",1,9,null,69,428]
[18,"MEREL","MEREL","DE LA TULLAYE Jean Emeline","Non","Avenue de l'Opéra","PARIS ",35000,"A","A",1,"droite","F3",4,12,null,62,392]
[1,"LAVIGNAC","BEAUGER Jacques",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","A",1,"gauche","F4",3,11,56,66,491]
[22,"VANNIER","DELEAU Emmanuelle",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","A",2,"droite","F3",6,14,null,63,387]
[13,"LE DEAN","LE DEAN Thérèse",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","A",2,"gauche","F4",5,13,55,null,479]
[21,"GEORGIN","SAILLANT Renée",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","A",3,"droite","F3",8,16,null,65,470]
[9,"SEGAUD","GAREL Cécile BELLEIL","DRUELE - MASCART","Non","Avenue de l'Opéra","PARIS ",35390,"A","A",3,"gauche","F4",7,15,49,null,474]
[30,"ROHOU","GOHIER Arnaud",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","AB",0,"droite","F4",17,25,54,68,505]
[7,"MOISON","DUBOIS Marie-Annick",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","AB",0,"gauche","F3",18,26,52,null,425]
[14,"CHÂTEAU","BUNEL Cédric",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","AB",1,"droite","F4",19,27,53,null,512]
[6,"LANE","CUPIF Monique","LE GALLIC","Non","Avenue de l'Opéra","PARIS ",35650,"B","AB",1,"gauche","F3",20,28,51,null,434]
[26,"QUENIART","LECHERBONNIER",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","AB",2,"droite","F4",21,29,null,71,348]
[24,"BEDIER","LE ROMANCER Nora",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","AB",2,"gauche","F3",22,30,null,70,392]
[25,"JOUSSELIN","JAMELOT - MAHAMODO",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"A","AB",3,"droite","F4",23,31,null,null,453]
[15,"LEBE","FILLODEAU Jocelyne","HOUEIX","Non","Avenue de l'Opéra","PARIS ",35000,"B","AB",3,"gauche","F3",24,32,50,null,429]
[23,"GUILLOU","HERRY Gauthier",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",0,"droite","F3",33,41,null,64,360]
[19,"ROLLAND","L.F.I  - SCHERMAN","MAHOIC-PRUD'HOMME","Non","Avenue de l'Opéra","PARIS ",35000,"B","B",0,"gauche","F3",34,42,null,null,392]
[8,"OLLIVIER","DURANDIERE Bernadette",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",1,"droite","F3",35,43,null,58,369]
[27,"ROHOU J-L","VASSEUR Caroline",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",1,"gauche","F3",36,44,null,60,369]
[2,"LE BEGUEC","BIDARD Christian",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",2,"droite","F3",37,45,null,59,369]
[29,"JOUVIN","RICHARD Antine",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",2,"gauche","F3",38,46,null,61,369]
[17,"BRASSELET","LERENARD",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",3,"droite","F3",39,47,null,67,364]
[3,"FINIEL","BIHAN Rozenn",null,"Oui","Avenue de l'Opéra","PARIS ",35000,"B","B",3,"gauche","F3",40,48,57,null,406]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R8:R31)","v":10000}]

{"sheet":"SUB","index":8,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE",null,null,null,"Les procédures et fonctions"]
[]
[null,"Les fonctions personnelles dans Excel"]
[null,"https://silkyroad.developpez.com/vba/fonctions/"]
[null,"Cours VBA : les procédures et fonctions"]
[null,"https://www.excel-pratique.com/fr/vba/procedures_fonctions"]
[]
[null,"Procédure Simple",null,null,null,"Appel de la Procédure",null,null,"Autre façon d'appeler la Procédure"]
[null,"Sub maPremiereProcedure()",null,null,null,"Sub maSecondeProcedure()",null,null,"Call maPremiereProcedure"]
[null,"     MsgBox \"Ceci est ma première",null,null,null,"     maPremiereProcedure"]
[null," procédure ! :)\"",null,null,null,"End Sub"]
[null,"End Sub"]
[]
[null,"Avec des Arguments"]
[null,"Sub exemple()",null,null,null,null,null,null,"Private Sub avertissement(texte As String)"]
[null,"    If Range(\"A1\") = \"\" Then    'Si A1 est vide",null,null,null,null,null,null,"    MsgBox \"Attention : \" & texte & \" !\""]
[null,"        avertissement \"cellule vide\"",null,null,null,null,null,null,"End Sub"]
[null,"    ElseIf Not IsNumeric(Range(\"A1\")) Then     'Si A1 est non numérique"]
[null,"        avertissement \"valeur non numérique\""]
[null,"    End If"]
[null,"End Sub"]
[]
[null,"ByRef"]
[null,"Sub exemple()"]
[null,"    Dim nombre As Integer",null,null,"Private Sub carre(ByRef valeur As Integer) "]
[null,"    nombre = 30",null,null,"'Il n'est pas nécessaire de préciser ByRef (type par défaut)"]
[null,"    carre nombre",null,null,"    valeur = valeur ^ 2"]
[null,"    MsgBox nombre",null,null,"End Sub"]
[null,"End Sub"]
[]
[null,"Une Fonction"]
[null,"Private Sub CommandButton2_Click()",null,null,null,null,null,"dblNombre récupère la valeur 40"]
[null,"    'Transmet la valeur 40 à la fonction \"Multiplication\".",null,null,null,null,null,"Function Multiplication(dblNombre As Double) As Double"]
[null,"    'La fonction renvoie 80.",null,null,null,null,null,"    'Multiplie l'argument dblNombre par 2 et renvoie le résultat au nom de la fonction."]
[null,"    MsgBox Multiplication(40)",null,null,null,null,null,"    Multiplication = dblNombre * 2"]
[null,"End Sub",null,null,null,null,null,"End Function"]
[]
[]
[null,"Passage de paramètre"]
[null,"Private Sub CommandButton3_Click()"]
[null,"    If Range(\"G37\") = \"\" Then",null,null,null,null,null,null,"Mettre un nombre ou un texte dans la cellule G37 puis cliquer sur le Bouton"]
[null,"            avertissement (\"La cellule vide\")",null,null,null,null,null,null,"OU"]
[null,"        Else",null,null,null,null,null,null,"Ne rien mettre dans la cellule G37 puis cliquer sur le Bouton"]
[null,"          avertissement (\"La cellule contient :  \") & Cells(37, 7)"]
[null,"    End If"]
[null,"End Sub"]
[null,"Private Sub avertissement(texte As String)"]
[null,"    MsgBox \"Attention : \" & texte & \" !\""]

{"sheet":"SELECTION","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[]
[null,"https://www.excel-pratique.com/fr/vba/selections"]
[]
[null,"http://www.webanalytix.fr/comment-selectionner-les-donnees-dun-tableau-excel-avec-vba/"]

{"sheet":"TRI","index":10,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[]
[null,"Tri de la colonne A en ordre croissant : ",null,null,null,null,"Tri de la plage A:H",null,null,null,"Plus simple"]
[null,"Columns(\"A:A\").Select",null,null,null,null,"Columns(\"A:H\").Select",null,null,null,"Il faut traquer les Select pour optimiser le code."]
[null,"Selection.Sort Key1:=Range(\"A1\")",null,null,null,null,"Selection.Sort Key1:=Range(\"A1\")",null,null,null,"Columns(\"A:H\").Sort Key1:=Range(\"A1\")"]
[]
[null,"Tri d'une plage nommée ADRESSE"]
[null,"Sub tri()"]
[null,"ActiveSheet.Range(\"ADRESSE\").Sort Key1:=ActiveSheet.[A2], Order1:=xlAscending, Header:=xlNo"]
[null,"End Sub"]
[]
[null,"Tri croissant de la colonne A1 et décroissant sur la colonne C"]
[null,"Sub tri()"]
[null,"Range(\"A1\").CurrentRegion.Sort key1:=Range(\"A1\"), order1:=xlAscending, dataoption1:=xlSortNormal, _"]
[null,"                               key2:=Range(\"C1\"), order2:=xlDescending, dataoption2:=xlSortNormal, Header:=xlYes"]
[null,"End Sub"]
[]
[]
[]
[]
[]
[]
[]
[null,"Avec l'enregistreur de Macros…..Et ça marche !"]
[null,"Tri sur la Colnne A de la sélection A1:B6 de la feuille PRENOM"]
[null,"Private Sub CommandButton1_Click()"]
[null,"    Sheets(\"PRENOM\").Select"]
[null,"    Range(\"A1:B6\").Select"]
[null,"    ActiveWorkbook.Worksheets(\"PRENOM\").Sort.SortFields.Clear"]
["Colonne A","Tri sur la Colnne A de la sélection A1:B6 de la feuille PRENOM"]
[null,"    ActiveWorkbook.Worksheets(\"PRENOM\").Sort.SortFields.Add Key:=Range(\"A1:A6\"), _"]
[null,"        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal"]
["Colonne B","Tri sur la Colnne A de la sélection A1:B6 de la feuille PRENOM"]
[null,"    ActiveWorkbook.Worksheets(\"PRENOM\").Sort.SortFields.Add Key:=Range(\"B1:B6\"), _"]
[null,"        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal"]
[null,"    With ActiveWorkbook.Worksheets(\"PRENOM\").Sort"]
[null,"        .SetRange Range(\"A1:B6\")"]
[null,"        .Header = xlGuess"]
[null,"        .MatchCase = False"]
[null,"        .Orientation = xlTopToBottom"]
[null,"        .SortMethod = xlPinYin"]
[null,"        .Apply"]
[null,"    End With"]
[null,"End Sub"]
[]
[]
[null,"TrI d'un tableau"]
[null,"    ReDim Tableau(0 To 9)"]
[null,"    For i = 0 To UBound(Tableau())"]
[null,"        Tableau(i) = Cells(i + 1, 1)"]
[null,"    Next i"]
[null,"   'Tri Décroissant"]
[null,"    Do "]
[null,"        Valeur = 0"]
[null,"        For i = 0 To UBound(Tableau) - 1"]
[null,"            If Tableau(i) < Tableau(i + 1) Then"]
[null,"                Cible = Tableau(i)"]
[null,"                Tableau(i) = Tableau(i + 1)"]
[null,"                Tableau(i + 1) = Cible"]
[null,"                Valeur = 1"]
[null,"            End If"]
[null,"        Next i"]
[null,"    Loop While Valeur = 1"]
[null,"    "]
[null,"    'vérification du tri décroissant"]
[null,"    For i = 0 To UBound(Tableau)"]
[null,"        Debug.Print Tableau(i)"]
[null,"    Next i"]
[null,"    'Pour obtenir un ordre croissant, il suffit de boucler du dernier élément du tableau, vers le premier."]
[null,"For i = UBound(Tableau) To 0 Step -1"]
[null,"        Debug.Print Tableau(i)"]
[null,"        Next i"]
[null,"End Sub",null,null,null,"http://www.expert-data.fr/tri-vba-excel/"]
[]
[null,"Tri sur une plage A3:F75 :"]
[null,"Range(\"A3:F3\").Select"]
[null,"Range(Selection, Selection.End(xlDown)).Select"]
[null,"ActiveWorkbook.Worksheets(\"Echeancier\").Sort.SortFields.Clear"]
[null,"ActiveWorkbook.Worksheets(\"Echeancier\").Sort.SortFields.Add Key:=Range( _"]
[null,"\"A4:A75\"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _"]
[null,"xlSortNormal"]
[null,"With ActiveWorkbook.Worksheets(\"Echeancier\").Sort"]
[null,"     .SetRange Range(\"A3:F75\")"]
[null,"     .Header = xlYes"]
[null,"     .MatchCase = False"]
[null,"     .Orientation = xlTopToBottom"]
[null,"     .SortMethod = xlPinYin"]
[null,"     .Apply"]
[null,"End With"]

{"sheet":"IMPRESSION","index":11,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[]
[]
[null,"https://excel.developpez.com/faq/?page=Impression"]
[]
[null,"https://docs.microsoft.com/fr-fr/office/vba/api/excel.sheets.printout"]
[]
[null,"https://docs.microsoft.com/fr-fr/office/vba/api/excel.pagesetup"]
[]
[null,"https://www.excel-pratique.com/fr/vba/proprietes"]

{"sheet":"INTERNET","index":12,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[]
[null,null,"Fonctions complémentaires XLP "]
[null,null,"Téléchargez et installez la macro complémentaire : pack_de_fonctions_xlp.zip"]
[null,null,"Comment installer un classeur de macros complémentaires"]
[null,null,"https://www.excelformation.fr/comment-installer-un-classeur-de-macros-complementaires.html"]
[null,null,"Un peu long mais bien expliqué"]
[null,null,"Liste des fonctions complémentaires Excel"]
[null,null,"https://www.excel-pratique.com/fr/fonctions-complementaires/fonctions-excel"]
[null,null,"Fonctions complémentaires VBA "]
[null,null,"https://www.excel-pratique.com/fr/fonctions-complementaires/fonctions-vba"]
[null,null,"Envoi d’email en VBA via Microsoft CDO"]
[null,null,"https://support.openhost-network.com/autres/programmation-developpement/envoyer-mail-vba-cdo/"]
[]
[null,null,"Vérification si je suis bien connecté à Internet"]

{"sheet":"HEURES","index":13,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,null,"Afficher les heures au-delà de 24H dans Excel"]
[]
[null,null,"https://www.excel-exercice.com/afficher-heures-au-dela-de-24h-excel/"]
[]
[null,null,"https://www.lecfomasque.com/excel-addition-heures/"]
[]
[null,null,"Pour le 25 décembre 2012 on saisira :",null,null,null,"2013-12-25"]
[null,null,"Nombre de jours entre 2 dates",null,null,"2000-03-15","2001-05-27",{"$f":"G9-F9","v":438},"jours"]
[null,null,"Que le jour",null,null,null,"2001-05-27",{"$f":"DAY(G10)","v":27}]
[null,null,"Que le mois",null,null,null,"2001-05-27",{"$f":"MONTH(G11)","v":5}]
[null,null,"Que l'année",null,null,null,"2001-05-27",{"$f":"YEAR(G12)","v":2001}]
[null,null,"Premier jour de la semaine",null,null,null,"2001-05-27",{"$f":"WEEKDAY(G13)","v":1}]
[null,null," les autres fonctions en cliquant en haut à droite sur la petite flèche des fonctions et choisir ",null,null,null,null,null,null,null,"Autres fonctions puis Date et heures"]
[null,null,null,null,null,null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,"saisir les heures avec comme séparateur les 2 points :",null,null,null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,"Exemple ","07:35:24","7 heures 35 minutes 24 secondes",null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,null,"18:05:22","18 heures 5 minutes 22 secondes",null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,"Total",{"$f":"SUM(D17:D18)","v":1.069976851851852},null,null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,null,null,null,null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,"Si cela ne fonctionne pas",null,null,null,null,null,null,null,null,"08:00:00",null,0.33333333333333331]
[null,null,null,"Sélectionner la zone qui contient les heures",null,null,null,null,null,null,null,{"$f":"SUM(L15:L21)","v":2.333333333333333},null,{"$f":"SUM(N15:N21)","v":2.333333333333333}]
[null,null,null,"Faire un clique Droit  et sélectionner",null,null,null,"Format de cellules",null,null,"Total Faux",{"$f":"SUM(L22)","v":2.333333333333333},"Total Bon",{"$f":"SUM(N22)","v":2.333333333333333}]
[null,null,null,"Onglet Nombre - Sélectionner  Personnalisé"]
[null,null,null,"Dans la zone Type taper : [h]:mm"]
[]
[]
[null,null,"1. Cliquez sur Fichier > Options."]
[null,null,"(Dans Excel 2007, cliquez sur Microsoft Office bouton"]
[null,null,"   , puis cliquez sur Excel Options.)"]
[null,null,"2. Cliquez sur Options avancées."]
[null,null,"3. Sous Lors du calcul de ce workbook,sélectionnez ou clear Use 1904 date system ( Utiliser le système de dates 1904)."]

{"sheet":"CARACTERE","index":14,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[null,null,"LES CHAINES DE CARACTÈRES"]
[]
[null,null,"https://silkyroad.developpez.com/VBA/ManipulerChainesCaracteres/"]
[]
[null,null,"https://www.excel-pratique.com/fr/fonctions-vba/texte"]
[]
[null,null,"https://www.dophis.fr/vba-manipuler-chaine-caractere-texte/"]

{"sheet":"PRENOM","index":15,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["PIERRE",1987,null,null,null,null,null,null,null,"PIERRE",1987]
["JULES",2001,null,null,"RETOUR",null,null,null,null,"JULES",2001]
["CATHERINE",1999,null,null,"Au….","SOMMAIRE",null,null,null,"CATHERINE",1999]
["MARCEL",1965,null,null,"Au….","TRI",null,null,null,"MARCEL",1965]
["ROBERT",1978,null,null,null,null,null,null,null,"ROBERT",1978]
["JUDITH",2010,null,null,null,null,null,null,null,"JUDITH",2010]

{"sheet":"Feuil1","index":16,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]

{"sheet":"Feuil2","index":17,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]

{"sheet":"Feuil3","index":18,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]
[12,"S.I.B","LE CORRE Sophie",null,"Oui","5 chemin des Ormes","RENNES",35000,"A","A",0,"droite","F3",2,10,null,72,383]
[16,"LENOIR","LOISEL Carole Lénaïc",null,"Oui","21 lieu dit Les Genêts","LA CHAPELLE DES FOUGERETZ",35520,"A","A",0,"gauche","F4",1,9,null,69,428]
[18,"MEREL","MEREL","DE LA TULLAYE Jean Emeline","Non","6 A Allée Adolphe Orain","RENNES",35000,"A","A",1,"droite","F3",4,12,null,62,392]
[1,"LAVIGNAC","BEAUGER Jacques",null,"Oui","5 chemin des Ormes","RENNES",35000,"A","A",1,"gauche","F4",3,11,56,66,491]
[22,"VANNIER","DELEAU Emmanuelle",null,"Oui","5 chemin des Ormes","RENNES",35000,"A","A",2,"droite","F3",6,14,null,63,387]
[13,"LE DEAN","LE DEAN Thérèse",null,"Oui","5 chemin des Ormes","RENNES",35000,"A","A",2,"gauche","F4",5,13,55,null,479]
[21,"GEORGIN","SAILLANT Renée",null,"Oui","5 chemin des Ormes","RENNES",35000,"A","A",3,"droite","F3",8,16,null,65,470]
[9,"SEGAUD","GAREL Cécile BELLEIL","DRUELE - MASCART","Non","1 rue Bertrand Du Guesclin","LA DOMINELAIS",35390,"A","A",3,"gauche","F4",7,15,49,null,474]
[30,"ROHOU","GOHIER Arnaud",null,"Oui","40  Bd de Cleunay","RENNES",35000,"A","AB",0,"droite","F4",17,25,54,68,505]
[7,"MOISON","DUBOIS Marie-Annick",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","AB",0,"gauche","F3",18,26,52,null,425]
[14,"CHÂTEAU","BUNEL Cédric",null,"Oui","40  Bd de Cleunay","RENNES",35000,"A","AB",1,"droite","F4",19,27,53,null,512]
[6,"LANE","CUPIF Monique","LE GALLIC","Non","38 rue du Grand Champ","LE RHEU",35650,"B","AB",1,"gauche","F3",20,28,51,null,434]
[26,"QUENIART","LECHERBONNIER",null,"Oui","40  Bd de Cleunay","RENNES",35000,"A","AB",2,"droite","F4",21,29,null,71,348]
[24,"BEDIER","LE ROMANCER Nora",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","AB",2,"gauche","F3",22,30,null,70,392]
[25,"JOUSSELIN","JAMELOT - MAHAMODO",null,"Oui","40  Bd de Cleunay","RENNES",35000,"A","AB",3,"droite","F4",23,31,null,null,453]
[15,"LEBE","FILLODEAU Jocelyne","HOUEIX","Non","20 rue Buferon","RENNES",35000,"B","AB",3,"gauche","F3",24,32,50,null,429]
[23,"GUILLOU","HERRY Gauthier",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",0,"droite","F3",33,41,null,64,360]
[19,"ROLLAND","L.F.I  - SCHERMAN","MAHOIC-PRUD'HOMME","Non","16 Square de la Rance","RENNES",35000,"B","B",0,"gauche","F3",34,42,null,null,392]
[8,"OLLIVIER","DURANDIERE Bernadette",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",1,"droite","F3",35,43,null,58,369]
[27,"ROHOU J-L","VASSEUR Caroline",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",1,"gauche","F3",36,44,null,60,369]
[2,"LE BEGUEC","BIDARD Christian",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",2,"droite","F3",37,45,null,59,369]
[29,"JOUVIN","RICHARD Antine",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",2,"gauche","F3",38,46,null,61,369]
[17,"BRASSELET","LERENARD",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",3,"droite","F3",39,47,null,67,364]
[3,"FINIEL","BIHAN Rozenn",null,"Oui","40  Bd de Cleunay","RENNES",35000,"B","B",3,"gauche","F3",40,48,57,null,406]

{"sheet":"Feuil5","index":19,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SOMMAIRE"]

{"sheet":"Feuil4","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}