Hi Excel Wizards!

I'm ok at excel and have made a fairly good Gantt chart thus far, however, I am stumped with a macro to Hide and unhide Row and Columns which do not fall into the projects duration days number and will reappear with date changes.

Example below, by changing the duration the dates will update the length of the project and add dates accordingly.

Conditional formatting is fine with highlighting dates are fine to change with planned and actual.

C D E F G
8 Start Date: 01-Jan-22 Duration: 400 Days
9 End Date: 05-Feb-23

when it reaches the end the remaining cells appear as such on the rows the columns just stay blank.

active Vertical section of the split rows 14 - 607



B C D E F G H
Planned Actual
Days Days

399 APPROVALS 3/02/2023 2 04/02/2023 3/02/2023 1 3/02/2023
400 APPROVALS 4/02/2023 2 5/02/2023 4/02/2023 1 4/02/2023
401 APPROVALS ####### #######


Horizontal section dates and highlighting section

column Ranges from J - AHR

unfortunately I cant share the file itself due to confidentiality issues as it is part of a tender package we are supplying.

Any help would be much appreciated.

Ta