Macro to Clear contents in a range of cells when Date change.

Friends,

I have a work sheet and on that I have datas in A7:A50. I need to clear the contents in that cell when the date change. More clearly. I am using that column for Remarks and, if I wrote something on that column being used only for today. next day morning I want that columns to be cleared. Kindly provide me a Macro for the same.

In which cell do you have the date value.

The logic would be to check if tocay() is greater than say Range("a1") (assuming that a1 has a date value.

Please Login or Register  to view this content.

Sir,

I put the date value in C1 and used excel formula =TODAY(). Also the problem is I am not manually entering any date. The date on that particular column will be automatically changed.

Sir, also I got a logic, I am already using some other macros to hide some columns based on today date. More clearly, I already inserted 1 to 31st dates in column B to Z ( assume) and on those columns 1 to 31 date is pre entered in each columns 2 ROW. So on today,the column which is having today's date only will be displayed (using a macro with workbook Open process). So that how about setting range as B to Z and start with if B= hidden then clear contents. On next day it has to calculate B+1 column ie, C has to check whether hidden or not, if hidden the column contents has to be cleared. Can we do like that Sir?

you can try this ,

Please Login or Register  to view this content.

alternatively you can use the column number instead of column name.

Please Login or Register  to view this content.

It would be better if you could post a sample workbook , marking your requirement.

Great,

You could solve this yourself, Please mark this thread as solved.