Need help with VBA code?

[cyrous0425]

https://drive.google.com/open?id=1k8QjVO4PLCvDd_699xf0qXIXNZ5XygbC Hey guys, I downloaded an excel sheet online and try to modify it but I am having trouble with it. I added column now the No. of days is now started in day 3 instead of 1 and also when I click on another month I want the previous column same with next month. Is it possible? I do't really need the column NL down to the last. Thanks

 

[thunder_anger]

hi
change in formula
change

COLUMN()-1

to

COLUMN()-3

a change in both macros

LeaveTracker.Columns("B:NI").Hidden = True

to

LeaveTracker.Columns("D:NL").Hidden = True

 

[cyrous0425]

I got another problem Sir. I changed the code as you mentioned but the month of January 30 and 31 was hidden. In the next month the days start on the second column. Would you mind looking at it again. Here's the link https://drive.google.com/open?id=162E8AdmYp5ngaFzz8-p-PlLiJOhMEpA8. Thank you.