1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152
| Range("A1").Select
Sheets("Bank").Select
Rows("3:3").Select
Selection.Delete Shift:=xlUp
Range("A1").Select
Sheets("Base").Select
Range("A3").Select
ActiveCell.FormulaR1C1 = "=Bank!RC"
Range("A3").Select
Selection.AutoFill Destination:=Range("A3:W3"), Type:=xlFillDefault
Range("A3:W3").Select
Range("B8").Select
Selection.Copy
Range("B3").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Range("A3:W3").Select
Selection.AutoFill Destination:=Range("A3:W59")
Range("A3:W59").Select
Range("A1").Select
Sheets("T²Bord").Select
Range("A1").Select
End Sub
Sub Macro3()
'
' Macro3 Macro
' Copier coller et additionner les nouvelles références dans Comp-Cell's et Compteur
'
' Touche de raccourci du clavier: Ctrl+s
'
Range("A1").Select
Sheets("Comp-Cell's").Select
Range("AB4:AU57").Select
Selection.Copy
Range("AY4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("AY60").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=R[-57]C+RC[-23]"
Range("AY60").Select
Selection.AutoFill Destination:=Range("AY60:AY114"), Type:=xlFillDefault
Range("AY60:AY114").Select
Range("AY61:AY114").Select
Selection.AutoFill Destination:=Range("AY61:BR114"), Type:=xlFillDefault
Range("AY61:BR114").Select
Range("AY60:BR114").Select
Selection.Copy
Range("AB60").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("AY60:BR114").Select
Selection.ClearContents
Range("AY60").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Range("A1").Select
Sheets("Compteur").Select
Range("AB4:AU57").Select
Selection.Copy
Range("AY4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("AY61").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=RC[-23]+R[-57]C"
Range("AY61").Select
Selection.AutoFill Destination:=Range("AY61:AY114"), Type:=xlFillDefault
Range("AY61:AY114").Select
Selection.AutoFill Destination:=Range("AY61:BR114"), Type:=xlFillDefault
Range("AY61:BR114").Select
Selection.Copy
Range("AB61").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("AY61:BR114").Select
Selection.ClearContents
Range("A1").Select
Sheets("T²Bord").Select
Range("A1").Select
End Sub
Sub Macro4()
'
' Macro4 Macro
' Tri final des données sur T²Bord
'
' Touche de raccourci du clavier: Ctrl+d
'
Range("D14:H14").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("K14").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("L14").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWorkbook.Worksheets("T²Bord").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("T²Bord").Sort.SortFields.Add2 Key:=Range("L14:L83" _
), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("T²Bord").Sort
.SetRange Range("K14:L83")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("O14").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWorkbook.Worksheets("T²Bord").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("T²Bord").Sort.SortFields.Add2 Key:=Range("O14:O83" _
), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("T²Bord").Sort
.SetRange Range("N14:O83")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With |