Excel Vba Typen Unverträglich?
Sub test()
For i = 1 To 10
Worksheets("Tabelle1").Range("C1:C10") = IIf((IsEmpty(Range("A1:A10")) + IsEmpty(Range("B1:B10"))) <> 0, "Not Calculable", (Range("A1:A10") - Range("B1:B10") + 1))
Next
End Sub
Microsoft Excel,
VBA,
Excel-Formel