nur ist das ganze super langsam, da wartet man gut 1 Minute eb das fertig ist...gibts da andere Möglichkeiten das zu beschleunigen?
Makro schaut so aus:
Dim Zelle As Range
For Each Zelle In ActiveSheet.Range("D6:AH369")
If Not Zelle.HasFormula Then
Zelle.ClearContents
Zelle.ClearComments
With Zelle.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Zelle.Font
.Name = "Arial"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
End If
Next Zelle