Hey Everyone!
I've created a Gantt chart that spans over 3 or 4 years (2013-2018) with conditional formatting and I want to make it automatically fill in dates at the end of the chart. I'm fairly new when it comes to using VBA and I'm having trouble with my code.
I managed to upload my chart so here it is!GANTT4-1.xlsm
I'm pretty much trying to find the earliest date out in Row 6 and then add a day to it so that whenever I press a button it will add the next day in the timeline. I know the problem is with the AddDate function but I have never used it before so I am not sure how to set it up. Any input would be great!Please Login or Register to view this content.
Bookmarks