If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GoBucks" wrote in message
...
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.