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
| Sub SelectionDonnées()
'
' SelectionDonnées Macro
'
'
Range("B:B,D:D,G:G,I:I,J:J,O:O").Select
Range("O1").Activate
ActiveWindow.SmallScroll ToRight:=8
Range("B:B,D:D,G:G,I:I,J:J,O:O,Q:Q,R:R,S:S").Select
Range("S1").Activate
ActiveWindow.SmallScroll ToRight:=4
ActiveWindow.SmallScroll Down:=-6
Range("B:B,D:D,G:G,I:I,J:J,O:O,Q:Q,R:R,S:S,X:X,Y:Y").Select
Range("Y1").Activate
ActiveWindow.SmallScroll ToRight:=9
Range("B:B,D:D,G:G,I:I,J:J,O:O,Q:Q,R:R,S:S,X:X,Y:Y,AD:AD,AF:AF,AG:AG,AH:AH"). _
Select
Range("AH1").Activate
Selection.Delete Shift:=xlToLeft
ActiveWindow.SmallScroll ToRight:=-21
Columns("J:J").Select
Selection.Cut
Columns("F:F").Select
Selection.Insert Shift:=xlToRight
ActiveWindow.SmallScroll ToRight:=6
Columns("S:S").Select
Selection.Cut
Columns("O:O").Select
Selection.Insert Shift:=xlToRight
ActiveWindow.SmallScroll ToRight:=-6
Rows("7:30").Select
Selection.Delete Shift:=xlUp
Columns("B:D").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = -0.149998474074526
.PatternTintAndShade = 0
End With
Columns("E:M").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorLight2
.TintAndShade = 0.799981688894314
.PatternTintAndShade = 0
End With
'dernière modifications de mise en forme
Columns("N:V").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
Range("G:G,H:H,J:J,M:M,P:P,Q:Q").Select
Range("Q1").Activate
ActiveWindow.SmallScroll ToRight:=8
Range("G:G,H:H,J:J,M:M,P:P,Q:Q,S:S,V:V").Select
Range("V1").Activate
Selection.Delete Shift:=xlToLeft
ActiveWindow.SmallScroll ToRight:=-8
ActiveCell.FormulaR1C1 = ""
Range("E3").Select
'intervertion Irradiance et Tmodule
Columns("D:D").Select
Selection.Cut
Columns("B:B").Select
Selection.Insert Shift:=xlToRight
'mise en place des formules pour Pac-Total et E-Total
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
ActiveCell.FormulaR1C1 = "Pac-Total"
Range("O6").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
ActiveCell.FormulaR1C1 = "W"
Range("O7").Select
ActiveCell.FormulaR1C1 = "=RC[-9]+RC[-4]"
Range("O7").Select
Selection.AutoFill Destination:=Range("O7:O69"), Type:=xlFillDefault
Range("O7:O69").Select
ActiveWindow.SmallScroll Down:=-72
Range("P5").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
ActiveCell.FormulaR1C1 = "E-Total"
Range("P6").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
ActiveCell.FormulaR1C1 = "Wh/15min"
Range("P11").Select
ActiveCell.FormulaR1C1 = "=((RC[-11]+RC[-6])-(R[-1]C[-11]+R[-1]C[-6]))*1000"
Range("P11").Select
Selection.AutoFill Destination:=Range("P11:P69"), Type:=xlFillDefault
Range("P11:P69").Select
ActiveWindow.SmallScroll Down:=-54
Range("O:O,P:P").Select
Range("P1").Activate
With Selection.Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent2
.TintAndShade = 0.599993896298105
.PatternTintAndShade = 0
End With
ActiveCell.FormulaR1C1 = ""
Range("Q2").Select
End Sub |
Partager