Hello,
I am new this Forum. I have tried multiple options from sources on the internet to get VBA to work for my problem, without success. So I thought I'd join this forum and see if anyone can assist.
The problem:
I would like the worksheet "Calendar" to automatically hide all columns with weeks that have passed.
The Trick:
One thing to note is that, the dates are written as week beginning, e.g. cell S3 is 14-Oct-19, representing week beginning Monday 14 October 2019 (today is 15-Oct-19) so I don't want this cell to be hidden, but all previous weeks should be hidden, e.g. Cells D3:R3 which go from 1-Jul-19 to 7-Oct-19. That is the column with the current week needs to remain visible even if the week beginning date has passed.
Full column date range is:
D3:DD3
Many thanks in advance for your someone's help?
Attachment:
How do I attach the uploaded file - Calendar worksheet?
Bookmarks