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
| Sub essaiv25()
ActiveWindow.SmallScroll Down:=9
Range("C17:M17").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=48
ActiveWindow.View = xlPageBreakPreview
Application.CutCopyMode = False
ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
ActiveWindow.SmallScroll Down:=24
ActiveSheet.HPageBreaks(1).DragOff Direction:=xlDown, RegionIndex:=1
ActiveWindow.View = xlNormalView
ActiveWindow.View = xlPageBreakPreview
ActiveWindow.SmallScroll Down:=30
ActiveSheet.PageSetup.PrintArea = "$C$1:$M$111"
ActiveWindow.SmallScroll Down:=54
Rows("70:70").Select
Range("B70").Activate
ActiveWindow.SmallScroll Down:=-54
Rows("17:17").Select
Range("B17").Activate
Selection.Copy
ActiveWindow.SmallScroll Down:=48
Rows("70:70").Select
Range("B70").Activate
ActiveSheet.Paste
Range("C70:I70").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=IF(RIGHT(R[-68]C[1],3)=""SAV"",R[-68]C[1]&"" N°""& TEXT(R[-67]C[-2],""aaaa"")&"" - ""&VLOOKUP(LEFT(R[-68]C[1],7),R8C1:R11C2,2,0),R[-68]C[1]&"" N°""& TEXT(R[-67]C[-2],""aaaa"")&"" - ""&VLOOKUP(RIGHT(R[-68]C[1],7),R8C1:R11C2,2,0))"
Range("C71").Select
ActiveWindow.SmallScroll Down:=6
Range("J70:M70").Select
ActiveCell.FormulaR1C1 = "= "" en date du ""&TEXT(R[-67]C[-9],""j mmmm aaaa"")"
Rows("64:65").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=45
Rows("105:105").Select
ActiveSheet.Paste
Range("H99").Select
ActiveWindow.View = xlNormalView
ActiveWindow.View = xlPageBreakPreview
Application.CutCopyMode = False
ActiveSheet.PageSetup.PrintArea = "$C$1:$M$180"
ActiveWindow.SmallScroll Down:=30
Set ActiveSheet.HPageBreaks(2).Location = Range("C112")
ActiveWindow.SmallScroll Down:=-108
Rows("17:17").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=99
Rows("115:115").Select
ActiveSheet.Paste
Range("C115:I115").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=IF(RIGHT(R[-113]C[1],3)=""SAV"",R[-113]C[1]&"" N°""& TEXT(R[-112]C[-2],""aaaa"")&"" - ""&VLOOKUP(LEFT(R[-113]C[1],7),R8C1:R11C2,2,0),R[-113]C[1]&"" N°""& TEXT(R[-112]C[-2],""aaaa"")&"" - ""&VLOOKUP(RIGHT(R[-113]C[1],7),R8C1:R11C2,2,0))"
Range("J115:M115").Select
ActiveCell.FormulaR1C1 = "= "" en date du ""&TEXT(R[-112]C[-9],""j mmmm aaaa"")"
Range("J122").Select
ActiveWindow.SmallScroll Down:=-51
Rows("64:65").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=99
Rows("175:176").Select
End Sub |