I have a workbook with tabs for each month. The range is the same for each monthly worksheet:
B2:AF2 - These are the days of month, formula populates each cell in range until the end of month. Feb would have a couple blanks for example as the range extends for 31 possible days.
If a cell in range B2:AF2 is blank, I would like to hide that column(s) automatically.
The range of dates is auto populated based on the year so I would not need to toggle a button to show/hide.
There are other worksheets in the workbook so globally would not work, just the monthly worksheets:
January
February
March
and so on...
Given the above for February, AE and AF should be auto hidden (2/30 and 2/31 do not exist, therefor blank).
B2:AF2 - These are the days of month, formula populates each cell in range until the end of month. Feb would have a couple blanks for example as the range extends for 31 possible days.
If a cell in range B2:AF2 is blank, I would like to hide that column(s) automatically.
The range of dates is auto populated based on the year so I would not need to toggle a button to show/hide.
There are other worksheets in the workbook so globally would not work, just the monthly worksheets:
January
February
March
and so on...
Given the above for February, AE and AF should be auto hidden (2/30 and 2/31 do not exist, therefor blank).