Hey all,
So I have this bit of code to scroll through dates using two shapes.
How would I go about changing these to look for the closest Monday? (forward and backwards)Sub WeeklyUp_Click() Range("WeeklyDate") = Range("WeeklyDate") + 7 End Sub Sub WeeklyDown_Click() Range("WeeklyDate") = Range("WeeklyDate") - 7 End Sub
Thanks in advance for your help.
Bookmarks