Code request to delete numbers in column B automatically

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'.

Please Login or Register  to view this content.

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,

Something like this will clear the cell from column B anytime you clear a cell in column C.

Please Login or Register  to view this content.

I have integrated the 2 codes but now I'm getting compile error 1004:
auto fill method failed

on line

Please Login or Register  to view this content.

If I delete the entire column 'C' then this error occurs.

Please Login or Register  to view this content.

Thanking you.