0 leden en 1 gast bekijken dit topic.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 8 Then If Target = "OK" Then [Done!A65536].End(xlUp).Offset(1).Resize(, 8) = Cells(Target.Row, 1).Resize(, 8).Value Target.EntireRow.Delete End If End IfEnd Sub