Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Column Hide
I want to hide each column that meets a certain condition. ie. I want to hide column 'B' if B3 < Today() or I want to hide column 'C' if C3 < Today(), an so on down the line. Yes, I want to hide each column where the date in row 3 is less than todays date. Kevin ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Column Hide
Dim cell as Range
for each cell in Range("A3:IV3") if not isempty(cell) then if isdate(cell.value) then if cell.Value < Date then cell.EntireColumn.Hidden = True else cell.EntireColumn.Hidden = false end if end if end if Next or for each cell in Range("A3:IV3") if not isempty(cell) then if isdate(cell.value) then cell.EntireColumn.Hidden = cellValue < Date end if end if Next -- Regards, Tom Ogilvy "firebird96" wrote in message ... I want to hide each column that meets a certain condition. ie. I want to hide column 'B' if B3 < Today() or I want to hide column 'C' if C3 < Today(), an so on down the line. Yes, I want to hide each column where the date in row 3 is less than todays date. Kevin ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Column If Usedrange of Column ISBLANK Follow-up | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK | Excel Discussion (Misc queries) | |||
Conditional Hide | Excel Worksheet Functions | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
Hide cell value conditional on its value | Excel Worksheet Functions |