VBA Skript funktioniert nicht
09.08.2013 12:52:51
Dominic
der folgende VBA Code funktioniert bei mir nicht. Excel gibt mir eine Fehlermeldung für den Teil "ActiveSheet.paste" aus.
Woran liegt das? Habt Ihr eine Idee?
Sheets("Überblick").Select
Range("A27:P2341").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Sheets("Export").Select
Range("B14:T2050").Select
Selection.ClearContents
Selection.FormatConditions.Delete
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Selection.Font
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
End With
Selection.FormatConditions.Delete
With Selection
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Rows("14:14").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.RowHeight = 15
Range("B14").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub