Hi,
Please suggest me a code to delete the serial number in column 'B' if the cell in column 'C' is blank or I deleted the value in column 'C'.

Private Sub Worksheet_Change(ByVal Target As Range)
'AutoSerialNumbers
    With Range("B6")
        .Value = "1"
        .AutoFill .Resize(Range("c" & Rows.Count).End(xlUp).Row - .Row + 1), 2
    End With
    MsgBox "Done!", 64
End Sub

In short if the cell in column 'C' is blank then there should not be a serial number in column 'B'. The code should run only when there is a value in column 'C' automatically. I want to insert this code in sheet module to run it automatically after theere is any change in column 'C'.

Any help will be appreciated.

Thanking you,