Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am a novice when it comes to writing VBA code, I would greatly
appreciate any help I can get in figuring out my ?. I would like to write a macro that automatically hides columns of data based on the value of a cell (I2) with a picklist. Cell I2's picklist is monthly values (formatted as Jan-10 though Dec-10 but real values are 1/1/2010 through 12/1/2010). I have a range that contains work week end date values (1/8/2010 to 12/31/2010) in L6:BK6. I would like to have the macro hide columns that are less than date value chosen in I2. For example, if a user selects "Mar-10" in cell I2, then columns L €“ S would automatically be hidden. However, if a user changed their mind and selected "Jun-10", columns L €“ AF would automatically be hidden. Thank you in advance for any help given. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding columns based on cell contents | Excel Programming | |||
Hiding rows or columns based on cell contents | Excel Discussion (Misc queries) | |||
Hiding columns based on row 4 criteria | Excel Worksheet Functions | |||
Hiding columns based on value | Excel Programming | |||
Hiding Columns based on value from another worksheet | Excel Programming |