Because once you delete the row, the cell value become unknown. Maybe put an error handle procedure
![]()
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ExitSub If Target.Value < 0 Or Target.Value > 1 Then Exit Sub Application.EnableEvents = False Target.Value = Target.Value / 60 Target.NumberFormat = "[m]:ss" Application.EnableEvents = True ExitSub: End Sub
Bookmarks