AW: Fehlende Zeile(n) mit Daten einfügen
26.05.2021 14:47:52
Werner
Hier mein VBA-Modul:
Option Explicit
Public Sub InsertMissingRows()
Dim lngRow As Long
Dim dtmNextTime As Date, dtmPreviousTime As Date
Dim avntTemp As Variant
With Worksheets("Laufzeit")
For lngRow = .Cells(.Rows.Count, 1).End(xlUp).Row To 3 Step -1
dtmNextTime = CDate(Split(.Cells(lngRow, 1).Value, " ")(1))
dtmPreviousTime = CDate(Split(.Cells(lngRow - 1, 1).Value, " ")(1))
If Round(CDbl(dtmNextTime - dtmPreviousTime), 4) > _
Round(CDbl(TimeSerial(0, 15, 0)), 4) Then
Call .Rows(lngRow).Insert
avntTemp = Split(.Cells(lngRow - 1, 1).Value, " ")
.Cells(lngRow, 1).Value = avntTemp(0) & _
Format$(dtmPreviousTime + TimeSerial(0, 15, 0), " Hh:Nn ") & avntTemp(2)
Call .Range(.Cells(lngRow - 1, 2), .Cells(lngRow - 1, 10)).Copy( _
Destination:=.Cells(lngRow, 2))
lngRow = lngRow + 1
End If
Next
End With
End Sub