Hi so sorry das erste Problem hab ich schon geloest
Public Sub FormelnSchreiben2()
If Not CheckSheet("Analysis") Then Sheets.Add
If Not CheckSheet("Analysis") Then ActiveSheet.Name = "Analysis"
Dim oBlatt As Worksheet
Dim iStartReihe As Long, iEndReihe As Long
Dim iStartSpalte As Integer, iEndSpalte As Integer
iStartReihe = 2
iStartSpalte = 2
iEndReihe = 5
iEndSpalte = 3
Set oBlatt = ThisWorkbook.Worksheets("Analysis")
With oBlatt
oBlatt.Range("e2").Formula = _
"=Sum(Data!" & .Range(.Cells(iStartReihe, iStartSpalte), _
.Cells(iEndReihe, iEndSpalte)).Address(0, 0) & ")"
oBlatt.Range("e3").Formula = _
"=Sum(Data!" & .Range(.Cells(iStartReihe, iStartSpalte), _
.Cells(iEndReihe, iEndSpalte)).Address(1, 1) & ")"
End With
Set oBlatt = Nothing
End Sub