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
| Sub tt()
Dim r As String
r = "A1:D4"
Range(r).Select
Range("A1:D4").Select
Range(Cells(1, 1).Address & ":" & Cells(4, 4).Address).Select
Range("A1", "D4").Select
Range(Cells(1, 1), Cells(4, 4)).Select
Range("A1").Resize(4, 4).Select
Range("E1").Offset(, -4).Resize(4, 4).Select
Application.Goto ActiveWorkbook.Sheets("Feuil1").Range("A1", "D4")
Application.Union(Range("A1", "B4"), Range("C1", "D4")).Select
Cells.ClearContents
Range("A1", "D4").Value = "test"
ActiveSheet.Range("a1", ActiveSheet.Range("D1").End(xlDown)).Select
ActiveSheet.Range("a1", ActiveSheet.Range("a1").End(xlDown).End(xlToRight)).Select
End Sub |
Partager