Auto_Open() How to show prior Monday?
This code gets me the 1st day of the current workweek. I need to edit it to
get the 1st day of the previous workweek.
Sub Auto_Open()
' Enter the prior Monday
Set StartDay = Sheets("SamB").Range("StartDay")
StartDay.Value = Date
Do Until Weekday(StartDay) = 2
StartDay.Value = StartDay.Value - 1
Loop
End Sub
I would appreciate your help.
Thanks,
Jeff
|