Hallo zusammen,
kann man diesen Code verkleinern ?
Sub Makro
Columns("C:C").Select
Selection.Copy
Sheets("Tabelle2").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("D:D").Select
Application.CutCopyMode = False
Selection.Copy
Range("C44").Select
Sheets("Tabelle2").Select
Columns("B:B").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("F:F").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Tabelle2").Select
Columns("D:D").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("E:E").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Tabelle2").Select
Columns("C:C").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("G:G").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Tabelle2").Select
Columns("E:E").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("J:J").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Tabelle2").Select
Columns("F:F").Select
ActiveSheet.Paste
Sheets("SpreadSheet").Select
Columns("L:L").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Tabelle2").Select
Columns("G:G").Select
ActiveSheet.Paste
Range("I4").Select
Columns("D:D").EntireColumn.AutoFit
Columns("C:C").EntireColumn.AutoFit
Columns("F:F").EntireColumn.AutoFit
Columns("G:G").Select
Application.CutCopyMode = False
Selection.TextToColumns Destination:=Range("G1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(10, 1)), TrailingMinusNumbers:=True
Columns("H:H").Select
Selection.ClearContents
Range("H1").Select
ActiveCell.FormulaR1C1 = "Bereich"
Range("H2").Select
End Sub
Danke