Auto Hide Columns based on date

[ExcelRoy]

Hi all,

Would it be possible to automatically hide columns based on todays date

I have a GANTT chart with dates in column (FM1:APX1) and would like to auto hide based on todays date

The week commencing todays date and 4 full weeks after tiodays date

Many thabnsk for any help

 

[ExcelRoy]

Hi,

Just one technical issue, the code doesnt automatically refresh
Can this refresh each time the workbook is opened

Thanks

 

[vladimiratanasiu]

Hi,

Just one technical issue, the code doesnt automatically refresh
Can this refresh each time the workbook is opened

Thanks

Just click once in the cell K4, and the non-ranged columns are collapsed automatically. Hide columns.xlsm

 

[vladimiratanasiu]

Perfect many thanks for your help vladimiratanasiu

I'm glad if I could help you. Thank you for your feedback!