Delete cell contents if the corresponding range is empty

Title clarification: Delete cell contents if the corresponding row range is empty

Hello, I currently have this code:

Please Login or Register  to view this content.

Whenever a cell is changed in rows 3:750 the date is added to the cell in the corresponding row if the column header contains "Date Last Modified". For example, if I changed cell E14 and the header of column T were "Date Last Modified", cell T14 would be filled with today's date.

My problem: if the rows between column C and the column containing "Date Last Modified" are empty, I would like the corresponding cell in column T to also be empty. Continuing the example, if I deleted everything in C14:S14, the date that was previously added to T14 would be removed. It should only ever be there if something between C14:S14 contains data.

I've attached an example spreadsheet. Thanks!

Example spreadsheet.xlsb

Originally Posted by stnkynts

Note: It can be dangerous having such an open worksheet_change event

Could you elaborate on this please? I'm unfamiliar with VBA.

Please Login or Register  to view this content.

Thanks for this. Is there a way of making it only activate when changes are made between rows 3 and 750 inclusive?

Many thanks for your help!