none
Clear Cell RRS feed

All replies

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

    Thursday, November 21, 2013 2:35 PM
    Answerer
  • 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

    Thursday, November 21, 2013 6:29 PM
  • @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

    Thursday, November 28, 2013 8:30 AM
  • 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.

    Friday, November 29, 2013 3:13 AM
    Moderator