I have a planning form I am using and want a macro that I can just push the button and auto clear content of cell ranges across the sheet. I already have an auto hide columns macro working. Now I need one that will clear contents for a range of rows up to the header with the date of yesterday. I need to keep the rows under the desired range as they have formulas. Row 1 has dates that spread through the end of the year. I will just say that rows C2:TH36 are the cells that need cleared daily or potentially weekly with the macro. But need it to only clear the rows and column data up to yesterday's date. I need to always keep A and B column data and anything from today's date and forward. Below the above mentioned cell range I have formula's and I do not want to have those cells contents deleted. Below is a snip of the columns. Row 1 is the dates and row 3 through 11 up to column AB needs cleared.