1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Range("A2:B2,E2:F2").Select
Range("E2").Activate
Selection.Copy
Sheets("Ma").Select
ActiveSheet.Paste
Sheets("Tous les compteurs").Select
Range("A3:B3,E3:F3").Select
Range("E3").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Ma").Select
Range("J7").Select
ActiveSheet.Paste
Sheets("Tous les compteurs").Select
Range("A11:B11,E11:F11").Select
Range("E11").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Ma").Select
Range("J8").Select
ActiveSheet.Paste |
Partager