Hello all,

Long time listener, first time caller.

I have an initial worksheet with today's date in cell C1 and the
worksheet name was created using this cell so my worksheets are listed
in date sequence. I also have vb code in a button that will add a new
worksheet, the same as the existing worksheet, using the current date
in format "mm-dd" as the worksheet name based on cell C1 (same as
before).

I wanted to know how to compare the cell value in the existing
spreedsheet with the newly created worksheet so the old sheet from
yesterday will display the date it was created instead of the current
date. Additionally, since the new worksheet will contain the same code,
how do I prevent the new worksheet from giving me errors since there is
nothing in front of it to compare. - Sorry if it sounds confusing.