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
| Sub Macro2()
'
' Macro2 Macro
'
Workbooks("XXXX").Worksheets("Sheet1 (2)").Activate
'
Columns("D:F").Select
Selection.Delete Shift:=xlToLeft
Columns("E:E").Select
Selection.Delete Shift:=xlToLeft
Columns("F:F").Select
Selection.Delete Shift:=xlToLeft
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
Columns("G:H").Select
Selection.Delete Shift:=xlToLeft
Columns("H:AB").Select
Selection.Delete Shift:=xlToLeft
Columns("I:V").Select
Selection.Delete Shift:=xlToLeft
Columns("A:H").Select
Selection.ColumnWidth = 15
Range("A1:H1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$H$2472").AutoFilter Field:=7, Criteria1:= _
"=[01.08.2014] . " _
, Operator:=xlOr, Criteria2:="=to be deleted"
Rows("29:29").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
ActiveSheet.Range("$A$1:$H$2436").AutoFilter Field:=7
ActiveSheet.Range("$A$1:$H$2436").AutoFilter Field:=1, Criteria1:=Array( _
"10", "11", "12", "13", "15", "16", "17", "19", "20", "23", "25", "27", "28", "30", "31", "32" _
, "33", "34", "35", "36", "37", "38", "39", "41", "42", "43", "45", "46", "47", "48", "5", "7", _
"8", "9"), Operator:=xlFilterValues
Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp
ActiveSheet.Range("$A$1:$H$2290").AutoFilter Field:=1
Range("A6").Select
ActiveWindow.SmallScroll Down:=-24
Call copypaste
End Sub |
Partager