Hi. How can I hide and unhide rows according to the day of the date? I have a dropdown menu in SHEET 1 so whenever I change the month, it will automatically place a "30" or "31" in the day cell. So I'm trying to hide a specific row in SHEET 2 whenever the selected day is 30. How can I do that? Also, is it possible that it will automatically hide or unhide whenever the month change? Thanks!
SHEET 1:
Capture.JPG
Hi, what if you place this code in a your worksheet module of "Sheet1":
Maybe you'll have to change the references to the ranges to your needs
Please Login or Register to view this content.
Cheers
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
It is not working.Originally Posted by Eastw00d
Hi, what if you place this code in a your worksheet module of "Sheet1":
Maybe you'll have to change the references to the ranges to your needsPlease Login or Register to view this content.
Cheers
Erwin
So, please can you upload a sample of your workbook?
Cheers
Erwin
Here's the workbook. I'm planning to hide the day 31 on the sheet 2 when the day of the month is 30. Thanks!
Last edited by cjvdg; 06-05-2020 at 03:25 AM.
Hi, so maybe this is the solution:
I cannot work it completely out, as the names of our months are not English, but I think it will work:
Made it also workable for the exception in FebruaryPlease Login or Register to view this content.
But I had to correct the formula:
CheersPlease Login or Register to view this content.
Erwin
Last edited by Eastw00d; 06-05-2020 at 06:52 AM. Reason: additional information
Thank you ver much! It is working!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks