Bitte um hilfe ich beiß hier auf Granit!
Danke
Sub MusterPrüfen()
lr = Worksheets(1).Range("c65536").End(xlUp).Row + 1
For j = 6 To lr
If Cells(j, 3).Value = Empty And Cells(j + 3, 3).Value = Empty And IsNumeric(Cells(j + 2, 3).Value) And IsNumeric(Cells(j + 1, 3).Value) Then
Cells(j, 4).Value = "*"
Cells(j + 1, 4) = "*"
Cells(j + 2, 4) = "*"
Cells(j + 3, 4) = "*"
End If
Next
End Sub
Sub MusterPrüfen()
lr = Worksheets(1).Range("c65536").End(xlUp).Row
For j = 6 To lr
If Cells(j, 3).Value = Empty And Cells(j + 3, 3).Value = Empty _
And IsNumeric(Cells(j + 2, 3).Value) And Cells(j + 2, 3) <> "" _
And IsNumeric(Cells(j + 1, 3).Value) And Cells(j + 1, 3) <> "" Then
Cells(j, 4).Value = "*"
Cells(j + 1, 4) = "*"
Cells(j + 2, 4) = "*"
Cells(j + 3, 4) = "*"
End If
Next
End Sub