Private Sub Workbook_BeforePrint(Cancel As Boolean) If Format(Date, "yymmdd") = Mid([A1], 4, 6) Then [A1] = "NO:" & Format(Date, "yymmdd") & Format(Right([A1], 4) + 1, "0000") Else [A1] = "NO:" & Format(Date, "yymmdd") & Format(1, "0000") End If End Sub