J J.W. Aldridge Jun 25, 2009 #1 on a newsheet workbook code, how to name sheet as yesterday's date? ie... yesterday was 6/24 = 6.24
M marcus Jun 26, 2009 #2 Hi J.W How about you try something like this. Adds a new sheet and places yesterdays date in mm/dd format. Take care Marcus Sub AddPriorDate() Dim Ws As Worksheet Dim MyDate As String MyDate = Format(Now() - 1, "mm.dd") Sheets.Add ActiveSheet.Name = MyDate End Sub
Hi J.W How about you try something like this. Adds a new sheet and places yesterdays date in mm/dd format. Take care Marcus Sub AddPriorDate() Dim Ws As Worksheet Dim MyDate As String MyDate = Format(Now() - 1, "mm.dd") Sheets.Add ActiveSheet.Name = MyDate End Sub
