Dim m As Integer
m = Month(Now)
With Sheets("TabEinAus").Cells(1, 1).CurrentRegion
With .Columns(.Columns.Count + 1)
If m = 1 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC5>0),1,""x"")"
ElseIf m = 2 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC6>0),1,""x"")"
ElseIf m = 3 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC7>0),1,""x"")"
ElseIf m = 4 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC8>0),1,""x"")"
ElseIf m = 5 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC9>0),1,""x"")"
ElseIf m = 6 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC10>0),1,""x"")"
ElseIf m = 7 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC11>0),1,""x"")"
ElseIf m = 8 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC12>0),1,""x"")"
ElseIf m = 9 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC13>0),1,""x"")"
ElseIf m = 10 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC14>0),1,""x"")"
ElseIf m = 11 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC15>0),1,""x"")"
ElseIf m = 12 Then
.FormulaR1C1 = "=IF(AND(OR(RC4=0,RC4=Year(Today())),RC16>0),1,""x"")"
End If
.EntireRow.Sort key1:=.Cells(1, 1), order1:=xlAscending, Header:=xlYes
AnzahlZeilen = WorksheetFunction.Sum(.Cells) + 1
.ClearContents
End With
End With
ich möchte aber, das die restlichen Zeilen ausgeblendet werden.Wie muss die Ergänzung heißen?
Viele Grüße Frank.