Clear Cell

Question

How do I clear a cell in excel once the date in the cell has passed?

Answer 1

Few things...

1.What is the scope? Is it for particular cells of all sheet in single excel file ? Or Single Worksheet ?

2.The date excel will use depend on PC system date.if it is changed wrongly your process may be affected.

---

Best Regards,
Asadulla Javed, Kolkata
---------------------------------------------------------------------------------------------
Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

Answer 2

Hello,

a little more background would help. Do you want to run the code manually or as an event? Is it just one cell or many?Something to get you started:

If Range("A1").Value < Date Then
    Range("A1").ClearContents
End If

---

cheers, teylyn

Answer 3

@George Hua -- How can this be an answer? It only asks questions and states a tidbit about system settings. It does not answer the question at all.

---

cheers, teylyn

Answer 4

Hi teylyn.

Since poster no continue, I mark the helpful reply as an answer.

Sorry for the confuse.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.