Hi
I know this problem has been visited a few times but I cant seem to get the various solutions to work.
I have an annual calendar showing only week commencing dates across the top of a table in row 5. the cells in row 5 contain the formulas to show the correct date for a particular year set in another cell.
I need some code so if the cell d5 for example returns no date then the column D needs to be hidden.
The row in question does contain more than 1 blank so D5 to BV5 is the range that any blank cell needs to have its own column hidden.
Thanks in anticipation.
Martyn
Bookmarks