Tried using various VBA to clear contents in column D but am having trouble doing so when column A has formulas in them. Basically what happens is that the A10 cell on the Notes sheet with the formula =IF(Transfers!D9="YES",Transfers!C9,"") may have once produced a value from a cell in another sheet but now is blank because the previous value was deleted from the other sheet. However, the D10 cell still has text in it which were manually written to briefly explain the reason for the "YES" value that was erased. The D10 cell does not have a formula in it. The leftover D10 cell contents needs to be cleared since they are no longer needed.

The A column has formulas in cells ranging from A6 to A260 which reference to cells on another sheet. The column cells D6 to D260 are related to them. How should the macro be written to clear the orphaned D columns cells when the Notes sheet is activated?

Thanks!